This is a very minor insignificant issue but it still bugs me that I can't figure it out.

On my financial reporter balance sheet my comparative columns use a different date format and I can't get them to match.
My current month date formula is: =ADGETF("gldates.END",FPRIOR(0))
The result it gives me is: 31-Jan-15
My prior year end date formula is: =GLFPE("LY")
The result is gives me is: 28-02-15

I'd like my prior year end date to read 28-Feb-15 ...is this even possible? I looked in the template files and couldn't figure it out.

Thanks,
Jean

Hi Jean,

Dates can be formatted in a number of different ways. For formulas GLFPS and GLFPE that output starting and ending dates for fiscal periods, there is a customization option that affects formatting. From the View menu, choose Customize, and on the Settings tab, there is a field labelled 'ColSpec date format'. Here you can enter the date formatting you require, such as dd-MMM-yy. This will affect all specifications.

If you only require this formatting for this statement, you can include additional information to the GLFPE formula to apply a different date format just to that cell. In your example, it would look something like either of these:

=GLFPE(G$6,"dd-MMM-yy")
=GLFPE("LY","dd-MMM-yy")

Hope this helps!

Brilliant! Totally worked and I'm a very happy person now.
Thanks tons!!