Topic Options
#71402 - 02/06/25 09:01 AM Financial Reporter Col spec columns
Liz_C Offline
Adagio Fan

Registered: 03/11/08
Posts: 36
Loc: Ontario, Canada
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??

Top
#71403 - 02/06/25 10:29 AM Re: Financial Reporter Col spec columns [Re: Liz_C]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hello Liz,

If you are using ColSpec, you can use =GLFPE.
_________________________
Regards,
Softrak Tech Support

Top
#71406 - 02/06/25 11:55 AM Re: Financial Reporter Col spec columns [Re: Softrak Support]
Liz_C Offline
Adagio Fan

Registered: 03/11/08
Posts: 36
Loc: Ontario, Canada
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

Top
#71407 - 02/06/25 01:02 PM Re: Financial Reporter Col spec columns [Re: Liz_C]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hello Liz,

I understand your question. Look up the function: =GLFPE, in the Help File in Financial Reporter.
_________________________
Regards,
Softrak Tech Support

Top
#71411 - 02/07/25 09:02 AM Re: Financial Reporter Col spec columns [Re: Softrak Support]
Liz_C Offline
Adagio Fan

Registered: 03/11/08
Posts: 36
Loc: Ontario, Canada
Sadly my help file is empty, however I did find an actual manual & was able to figure it out. Thank you for your assistance.

Top


Moderator:  Softrak Support 
Who's Online
1 registered (Tanya_Belanger), 189 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14448 Topics
70593 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30