Discussion Board for collaboration on QlikView Scripting.
i need the intervall between two dates.
First date = 9/2/2009
Second date = 11/20/2009
The result should be look like this: 9,10,11 or sep,oct,nov
Thank you for your time
Go to Solution.
I'd use something like
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.
Thank you for your fast response