# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Not applicable

## How to get the intervall between two dates

Hello,

i need the intervall between two dates.

Example:

First date = 9/2/2009

Second date = 11/20/2009

The result should be look like this: 9,10,11 or sep,oct,nov

1 Solution

Accepted Solutions
Employee

Hello,

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);`
adding any other additional field you want to use (week, day of week, quarter...).

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.

2 Replies
Employee

Hello,

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);`
adding any other additional field you want to use (week, day of week, quarter...).

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.

Not applicable
Author

Thank you for your fast response