Print Yesterdays date on header 1

[nvrmaried]

I am not a Crystal expert. I "fix" and create simple reports when required.

I have a report that uses formula that uses "CURRENTDATE -1" to select data.
I need to print yesterdays date on the report. Is there an easy way to accomplish this?

I have just been using "Printdate" from the special fields, but they want the date the data is from.

Thank You,

Steve

 

[lbass]

You can use:

datadate

...which is found in the Special Fields category of the field explorer. Note you could also use a formula:

currentdate-1

...and place it in the header.

-LB

 

[nvrmaried]

Thank you LB.

I have not had any luck using datadate. It just shows todays date, even though the data is from yesterday.

The CURRENTDATE-1 formula worked.

Thank you very much!!!!
Steve

 

[lbass]

I'm sorry, actually datadate will show you the date the report was last refreshed, not the date of the data in the report. The print date will show the date the report was last opened, i.e., today's date.

-LB