Help with date formulas!!!

[PQTIII]

If it is the 1st of the month I want to run last month's report. If not I want to have it run MTD. I have this formula in the select expert section for the date range, but it doesn't work. Is there a diffent way to do this?


if CurrentDate = Date(1) then {930_OEE.shiftdate} in LastFullMonth else {930_OEE.shiftdate} in MonthToDate

Thanks PT

 

[dgillz]

if Day(CurrentDate) = 1 then {930_OEE.shiftdate} in LastFullMonth else {930_OEE.shiftdate} in MonthToDate


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

http://www.srhconsulting.com

 

[PQTIII]

Works great! Thanks so much for your help.

Paul