Fiscal Calendar for Canonical Dates Calendar

[#1]

Hi Guys,

I have a master calendar and I am using same script as mentioned in the below post

Creating A Master Calendar

Where do I have to modify the script to get Financial Year field like below

2014-15

2015-16

2016-17

[#2]

Hi Lokesh,

Please look at this from HIC. Calendars

Go for the 4th section of the script.

Thanks,

Ram

[#3]

or simply try this one. With this script you get both the Year in a number format and also in the format you required.

Thanks.

Set vFM = 4 ;                                                          // First month of fiscal year

Calendar:
Load Dual(fYear-1 &'-'& fYear, fYear) as FYear,          // Dual fiscal year
         Dual(Month, fMonth)                as FMonth,           // Dual fiscal month
          *;
Load Year + If(Month>=$(vFM), 1, 0) as fYear,           // Numeric fiscal year
         Mod(Month-$(vFM), 12)+1        as fMonth,          // Numeric fiscal month
          *;
Load Year(Date)                              as Year,           // Your standard master calendar
         Month(Date)                            as Month,

[#4 · Accepted solution]

Thank you

I added following in my master calendar script.

Text file attached.

thanks