Fiscal Month Day Number

[#1]

Hi All

I have a fiscal month field. Fiscal month starts on the 26th to the 25th of the following month. I would like to create a field to num() my fiscal month days. Eg 26th Jan would be day 01 and 25th Feb will be day 31. How can I do this?

[jagan · Accepted solution]

Hi,

Try like this

MasterCalendar:

LOAD Date,

Date(monthstart(Date-25,1),'MMM-YYYY') as Month,

Day(Date(Date-25)) AS Day ;

LOAD

Date(makedate(2015)+recno()-1) as Date

AutoGenerate 732;

Hope this helps you.

Regards,

Jagan.

[#3]

Thanks Jagan...Always a great help!

[jagan]

Hi,

Check this link for details

Fiscal Calendar with Non-Standard Days (Not 1-31)

Regards,

Jagan.