Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Fiscal Year Calendar

I have this script as fiscal year calendar:

FiscalYear:

Set vFM = 4;

Load Dual(Month, (Mod(Month-$(vFM), 12)+1))             as FMonth,           // Dual fiscal month

Year + If(Month>=$(vFM), 1, 0) -1 as fYear,           // Numeric fiscal year

        Mod(Month-$(vFM), 12)+1         as fMonth,          // Numeric fiscal month

          *

Resident Calendar

order by Year,Month asc;

and i use this expression for my calendar to get the first date of year in normal calendar (calendar year): =YEARSTART(MAX(DATEPERIOD)

when i use it in fiscal year, it works for months that is in the same year (from april to dec i get ' April 1st' from that expression)

but when i select jan-mar i get 'January 1st' as the first date. how could i get also April 1st as the first date of fiscal year?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Mike,

maybe

YearStart(Max(DATEPERIOD),0,vFM)

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi Mike,

maybe

YearStart(Max(DATEPERIOD),0,vFM)

Regards,

Antonio

Anonymous
Not applicable
Author

that's great. thanks so much