display name of last month on report

[Mike Hughes]

I have a report that I run at the start of each month. The data is from the previous month so I would like to add something to the report to display the name of last month and the year. Can this be done and how?

Thanks

Mike

 

[Brianwarnock]

Try

=Format(DateAdd("m",-1,Date()),"MMM")


Brian

 

[Mike Hughes]

That did the trick. Thanks for the help.

Mike