Master /Fiscal Calendar

[jjking58]

I created a Master Calendar and added Fiscal fields (Year,Month,Quarter.). Neither calendar seems to be working correctly.

I wanted the Fiscal period to start in April and include only years 2015, 2016.

The results are pulling all dates for years 2013,2014,2015 and the fiscal months are not working at all.

The following is the Master Calendar code and the table file.

The (IHIDAT is formatted in the table(Inv_Header) (as YYYYMMDD) if this helps

Please advise

Thanks,

Jim

[vinieme12]

try this one

Fiscal and Standard Calendar generation

[jjking58]

I've tried this and it seemed to work for the current fiscal year, but i was unable to generate the previous year correctly. Especially when displaying 2016 Apr-Jan and then 2015 Apr-Jan

Can you explain how to do this?

Thanks