topic Difference between dates from different month in QlikView

Difference between dates from different month

Wed, 09 May 2012 15:06:09 GMT

Hi all

I have a question that maybe you know the answer. I have to substract two different dates but each of those belongs to different months. For example this code equivalent to this code in c#

DateTime dt1 = new DateTime(2012, 05, 07); //YYYY/MM/DD

DateTime dt2 = new DateTime(2012, 03, 06);

int days = (dt2 - dt1).Days; // 62 days

Somebody know the trick?

Thanks in advance

Difference between dates from different month

Wed, 09 May 2012 15:11:18 GMT

Try using the Interval function - Interval(DateTime1 - DateTime2). Just be aware that it is a date and time interval so for just days difference.

Difference between dates from different month

chematos — Wed, 09 May 2012 15:15:13 GMT

Hi,

I,ve tried creating a variable with makedate(2012,02,02) and the result of Today()-$(vDate) is 97.

You must be sure that the type of the dates is the same for both of them and it must work.

Regards