Using Now() in a Report Header

K

Keith Woollacott

I have a report that has the following in the header - "Deposits for the
month " & Format (Now(), "MMMM YYYY").

This works fine, but my boss now wants the report to be run at the beginning
of the month to show last months figures. How can I get the Format Now() to
show the previous month?
 
A

Allen Browne

Try using DateAdd() like this:

= Format(DateAdd("m", -1, Date()), "mmmm yyyy")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Top