Show previous month

[sg]

Hi,

I like to show previous month on the report during current month, how could
I do this?

Appreciate any help,
Sarah

 

[Rick Brandt]

Hi,

I like to show previous month on the report during current month, how could I
do this?

Appreciate any help,
Sarah

DateField Between DateSerial(Year(Date), Month(Date)-1,1)
AND DateSerial(Year(Date), Month(Date),0)

The above assumes that your date fields have no time component (all are exactly
midnight). If they do have times other than midnight then use...

DateField Between DateSerial(Year(Date), Month(Date)-1,1)
AND DateSerial(Year(Date), Month(Date),1)

 

[sg]

Hi Rick

This is very good. But it shows the general date, can I just show month?
Thanks,
Sarah