Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Mike,
maybe
YearStart(Max(DATEPERIOD),0,vFM)
Regards,
Antonio
that's great. thanks so much