topic How to get the intervall between two dates in QlikView

How to get the intervall between two dates

Wed, 03 Mar 2010 11:55:43 GMT

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

Thank you for your time

How to get the intervall between two dates

Miguel_Angel_Baeyens — Wed, 03 Mar 2010 12:02:31 GMT

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.

AW:Re: How to get the intervall between two dates

Wed, 03 Mar 2010 12:19:48 GMT

Thank you for your fast response