am completely on brain lock and am trying to add to a current report using the formula below.  We use 01/01/1800 to pull previous month on most our reports. Today we wanted to 'add' using 01/01/1950 to this formula, to pull Current Month To Date and I am just stumped on something I know is easy.  Looking for a little help and apologize for the simplicity of the question. BRAIN  SORRY!

Yes, we use the results for the data pull..but your idea works on many other reports THANK YOU!  This didn't work on the specific report I am using right now.

BEG DATE:

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

If {?Beg Date} = Date(1800,01,01) Then

Date(Year(EndMonth),Month(EndMonth),01)

END DATE:

If {?End Date} = Date(1800,01,01) Then

Date(Year(DataDate),Month(DataDate),01)-1

Else

If {?End Date} = Date(19501,01) Then currentdate

Edited by DBlank - 30 Oct 2013 at 10:15am