5 Replies Latest reply: Oct 17, 2016 1:20 AM by kumarsuresh lulu

# How to convert 4-5-4 calendar to Normal Calendar

Hi,

We have 4-5-4 retail calendar, how to convert this calendar to normal calendar?

Thanks,

• ###### Re: How to convert 4-5-4 calendar to Normal Calendar

Hi,

I hope some one has worked on this scenario, can you please help me here.

Thanks,

• ###### Re: How to convert 4-5-4 calendar to Normal Calendar

Try this solution

Canonical Date

• ###### Re: How to convert 4-5-4 calendar to Normal Calendar

The specific of the 4-5-4 calendar is that it uses retail periods, more or less approximate to months, with length of 4 weeks, 5 weeks, and 4 weeks in each retail quarter.  So, you need to use "normal" months and quarters instead of the retail periods.  If you have Date field, the Month-Year will be:

Date(monthstart(Date), 'MMM-YYYY') as MonthYear

Quarter:

'Q' & ceil(month(Date)/3) & '-' & year(Date)

• ###### Re: How to convert 4-5-4 calendar to Normal Calendar

This one: 4-5-4 Master Calendar is the opposite and I think you could reverse the logic and/or use them as mapping to your calendar.

- Marcus

• ###### Re: How to convert 4-5-4 calendar to Normal Calendar

Hi,

Thanks for your valuable posts, I got it.

Thanks,