Using Now() in a Report Header

[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?

 

[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]...

 

[Keith Woollacott]

Allen - Many thanks for the prompt and helpful answer