Report date using special Field "DATADATE"

[JJtwin]

Hi,

I am new to Crystal reporting. I need to produce a Monthly report, and I am using special field "DataDate and customize it to show Month and Year. But my report date needs to show previous month instead of current month. For example, if i run the report today, it should have show April 2008 instead of May 2008. Would you please tell me the formula I should be using to get April 2008 instead of May 2008 ?

Thanks

 

[boblarson]

Look in the functions for DateAdd and use -1 for the number of intervals of "M"

 

[Kempes]

Can I just ask, are the records actually showing for the last month? Is this what you want it to do?

Datadate will show a date when the data was retrieved for the report.

If you want the actual data to show for the last month, you will need to open the select expert (which is basically your where part of the select statement), choose the date field from your table, choose "is in the period", then select "last full month".

You can also pull this date field in your report header and format it to be month, Year.

No formula field is required doing it this way.