I am trying to create a string that returns the date as follows:
March 31, 2006 with comparative figures for 2005
Presently I can get everything except the year 2005. I only know how to get 2006 to show up. The formula I have in at this point is:
=DATESTRING(ADGETF("gldates.END",FPRIOR(0)),"%B %d, %Y with comparative figures for %Y")
I know the %Y is wrong, but what do I need to do to get the prior year (that is 2005).
_________________________
Thanks,
Ken Aberdeen,CPA, CMA
Aberdeen Business Consulting Ltd.
ken@aberdeenconsulting.ca