445 Calendar

[danny4202001]

Hello Friends,

How do I create 445 calendar months with Sunday as the start date and the last Saturday as the month's end.

I did create this script, Buts weeks are not falling in to correct month, for example, Jan is ending on 02/23  supposed to be end on 01/28 according to 445

Set vCal_FD = 6;
Set vCal_RD = 7;

Date( WeekStart( $(CancelDateOO), 1, $(vCal_FD) ) - $(vCal_RD) ) as week startdate,
Num(Month(floor( WeekStart( $(CancelDateOO), 1, $(vCal_FD) ) - $(vCal_RD) ))) as MonthNum,

202301	01/01/23	01/28/23
202302	01/29/23	02/25/23
202303	02/26/23	04/01/23
202304	04/02/23	04/29/23
202305	04/30/23	05/27/23
202306	05/28/23	07/01/23
202307	07/02/23	07/29/23
202308	07/30/23	08/26/23
202309	08/27/23	09/30/23
202310	10/01/23	10/28/23
202311	10/29/23	11/25/23
202312	11/26/23	12/30/23

[Bill_Britt]

Hi,

Take a look at this.

https://community.qlik.com/t5/Design/Recipe-for-a-4-4-5-Calendar/ba-p/1464069