Show previous month

S

sg

Hi,

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

Appreciate any help,
Sarah
 
R

Rick Brandt

sg said:
Hi,

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

Appreciate any help,
Sarah
Click to expand...

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)
 
S

sg

Hi Rick

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