Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Hi,
Take a look at this.
https://community.qlik.com/t5/Design/Recipe-for-a-4-4-5-Calendar/ba-p/1464069