I want to use this formula =STRCAT("For the ",FPERIOD()," Period(s) Ending ",DATESTRING(ADGET("gldates.END",FPRIOR(0)),"%B %d, %Y")),which currently translates to "For the 6 Period(s) Ending June 30, 2009". Except I'd like my report to have solely last years data on it, so I'd like to change the year to last year, so "June 30, 2008".

Can someone tell me how I might do this?

Thanks


Edited by Mikee (06/08/09 02:23 PM)