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