Trying to do a comparison year over year for a specific month. Want to compare the last 3 years. I am able to get the date using LYM, {2}M, and {3}M.
But when it comes to the auto population of the date, I can't get anything past 13 months.

If I enter =DATESTRING(ADGET("gldates.END",FPRIOR(24))," %B %Y")

it give me a date of December 1899 instead of February 2023

What am I missing here??

Hello Liz,

If you are using ColSpec, you can use =GLFPE.

I don't think I know enough about the terminology - underneath the ColSpec row are the column headers - they aren't displaying properly for the 2 year & 3 year prior to the current fiscal year. So if I have January 2025, 2024, 2023 & 2022 - the 2023 & 2022 column headers are showing December 1899

i would love to leave a screenshot, but I can't

Hello Liz,

I understand your question. Look up the function: =GLFPE, in the Help File in Financial Reporter.

Sadly my help file is empty, however I did find an actual manual & was able to figure it out. Thank you for your assistance.