Display month name and year in title 1

[moopenguin32]

I have a report that is pulling data using LastFullMonth. In the title of the report, I would like to display the month and year the report is for.

For example, if I run the report in February, I would like the title to display "January 2009." Likewise, if I run the report in January, I would like it to display "December 2008."

Currently, I know how to make it show just the month by using the following formula:

monthname(month(DateAdd ("m", -1, DataDate)))

Thank you for your assistance.

"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

 

[lbass]

You could use:

totext(minimum(lastfullmonth),"MMMM yyyy")

-LB

 

[moopenguin32]

Worked like a charm. Thanks again for your help.

"Remember, today is the tomorrow you worried about yesterday." - Dale Carnegie

 

[IanWaterman]

YOu can derive year in same way

year(DateAdd ("m", -1, DataDate))

if you need it in Text

totext(year(DateAdd ("m", -1, DataDate)), 0, "")

Ian