This content has been marked as final. Show 2 replies
I'd use something like
adding any other additional field you want to use (week, day of week, quarter...).
LET vFirstDate = Num(Date('StartingDateHere'));LET vSecondDate = Num(Date('EndingDateHere'));TempCalendar:LOAD MakeDate(Year($(vFirstDate)), Month($(vFirstDate)), Day($(vFirstDate))) + Iterno() - 1 AS TempDate, Month(Date($(vFirstDate))) AS TempMonth, Day(Date($(vFirstDate))) AS TempDayAUTOGENERATE 1 WHILE $(vFirstDate) + Iterno() - 1 <= $(vSecondDate);
I'd suggest you to create a master calendar if you have not done it yet. There are several threads in the forum and blogs about how to do it. You can check here.