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,