Prior week Formula?

[Former Member]

I need a formula that will display the prior week in a report, so when i upload the report to Crystal Server it automatically refreshes the report with the prior week and emails it out. Can somebody help me with this?

thanks,

Nick

[Former Member · Accepted solution]

Try using record selection formula and write

{date field} in LastFullWeek

which returns the data for last week

Regards,

Raghavendra

[Former Member · Accepted solution]

Thank you, How would I get yesterday?

[Former Member · Accepted solution]

To get yesterday data then try

=currentdate-1

Regards,

Raghavendra

[Former Member · Accepted solution]

That gives me a Boolean, I need a date.

[Former Member · Accepted solution]

Oh you want yesterday date? not record selection?

then createa formula like

currentdate-1

this gives yesterday date

Regards,

Raghavendra