Fiscal Year Calendar

Anonymous — Wed, 26 Jul 2017 04:28:41 GMT

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?

Re: Fiscal Year Calendar

antoniotiman — Wed, 26 Jul 2017 04:44:53 GMT

Hi Mike,

maybe

YearStart(Max(DATEPERIOD),0,vFM)

Regards,

Antonio

Anonymous — Wed, 26 Jul 2017 04:55:55 GMT

that's great. thanks so much