Discussion Board for collaboration related to QlikView App Development.
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
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.
View solution in original post
Thank you for your fast response