Print LastFullMonth in Report Title 2

[loveyoursite]

CRV10 - I have a termination report that when run will generate a list of employees with a termination date is in the period LastFullMonth. So if I run the report on any day during a month, it will always give me the previous full month.

Could someone please tell me how to get the LastFullMonth and year printed in the report title? I'm looking for something like April 2005 Terminations.

Thanks!

 

[synapsevampire]

Try:

monthname(month(minimum(lastfullmonth)))& " " & year(lastfullmonth)

Note that you can use minimum and maximum against ranges, so if you wanted the actual dates you'd simply use:

minimum(lastfullmonth)& " to "& maximum(lastfullmonth)

-k

 

[synapsevampire]

I should have qualified in case your numeric settings differ from mine:

monthname(month(minimum(lastfullmonth)))& " " & totext(year(lastfullmonth),0,"")

-k