Date Help

[pungigis]

Ok, currently I have the ability to run a report on

currentdate - 1 to return yesterdays data, I need to be able to do the same thing only for months, I need to be able to run monthly for prior 2 months of data, can I use lastfullmonth function or is there an easier way???

 

[lbass]

Try:

{table.date} in dateserial(year(currentdate),month(currentdate)-2,1) to
dateserial(year(currentdate),month(currentdate),1)-1

-LB

 

[dgillz]

Or checkout the dateadd() function in help. You did not mention what version of crystal you have, I believe dateadd() made its debut in crystal 8.5.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?