Skip to Content
0
Former Member
Jul 01, 2009 at 10:40 PM

Formatting Previous Month/Year date display

21 Views

Hi all,

I set this formula to provide a field displaying the 'previous month and year' for the report selection:

formula = monthname(month(dateadd("m",-1,CurrentDate)))& " " & Year({Application_Facts.Application_Date})

however, it displays the following:

June 2,009.00

I have search hi&lo to get the year displayed as 2009 but am stuck. Can you help?

Thanks,