topic Calculate the difference between today and a future date in QlikView

Calculate the difference between today and a future date

Anonymous — Tue, 31 May 2011 14:03:29 GMT

Hello! I wonder how I can calculate the difference in days between today and a future date.

The dateformat I'm using is YYYY-MM-DD.

So how do I do to caluclate the difference between today, 31 st of May, and for example 17 th of June?

And if I want to exclude weekends (they should not be calculated) how do I do then?

Thanks in advance

Calculate the difference between today and a future date

Tue, 31 May 2011 14:11:53 GMT

Hi,

you should be able to use the function networkdays() as follows:

networkdays(today(),makedate(2011,6,17))

The function eliminates Saturdays and Sundays. You could also add dates as a third parameter that should not be counted, such as national holidays. See the QV help for reference.

Good luck,

Jonas, QlikView Consultant @ Optivasys | www.optivasys.se

Calculate the difference between today and a future date

Anonymous — Tue, 31 May 2011 14:33:29 GMT

Thanks for your answer