We have decided to standardize some date prompts in our reports as an example:


01/01/1800 - Previous Month
01/01/1850 - Previous 7 days
01/01/1900 - Previous Day
01/01/1925 - MonthYTD

I have tried just about every way of getting these all on one report for the end users and cannot get any which way to work.

Anyone have any ideas or suggestions? Greatly Appreciated!

So sorry - we have had some major issues going on and I wasn't able to reply until now.
We are trying to standardize our Crystal reports so that if the end users want to run it and only bring back the last full week's data, they can do that or if they want the last full month they can do that too.
So for now, I am trying to get the just previous month and the previous week to work and cannot get anything to work.
Here is what I have using monthly and this works fine alone: How do I add the previous full week using parameters of 1850,01,01?

dateVar EndMonth := Date(Year(DataDate),Month(DataDate),01)-1;

If {?Starting Date for Report} = Date(1800,01,01) Then
Date(Year(EndMonth),Month(EndMonth),01) Else
{?Starting Date for Report}

Thank you so much in advance for your help and patience!