Using Now() in a Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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]...
 
Back
Top