Show previous month

  • Thread starter Thread starter sg
  • Start date Start date
S

sg

Hi,

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

Appreciate any help,
Sarah
 
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)
 
Hi Rick

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