need a field to show the last day of the previous month 1

[farrelm2]

I am using the lastfullmonth function in my report. I will be running the report on the 1st day of every month. On my report, I need to print a field to show the last day of the previous month. For example, I ran the report on Oct. 1, but need the report to read "For month ending September 30, 2002." I need a field to update each month. Any ideas?

 

[Naith]

A formula saying CurrentDate-Day(CurrentDate) should do this.

Naith

 

[goranm]

Hi!

If you want the complete sentence you can write this formula:

'For month ending ' + ToText(Maximum(LastFullMonth),'MMMM dd, yyyy')

/Goran

 

[Naith]

Very nice, Goran.