topic Re: Calculate date difference in QlikView

Calculate date difference

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,i want to ask how can i calculate the date difference of today and the date of a set of data

I have tried to use DATE1-DATE2 but it's ineffective

For example =Floor(Interval(2017/7/19-last_stat_date,'DD'))

what function should i use?

Anil_Babu_Samineni — Wed, 19 Jul 2017 15:32:32 GMT

May be this?

NetWorkDays(Today(), last_stat_date)

passionate — Wed, 19 Jul 2017 15:37:58 GMT

Best way to handle date calulations like differences is using numeric date values:

Num(Date1)- Num(Date2)

MarcoWedel — Wed, 19 Jul 2017 23:09:11 GMT

Try enclosing your static date in single quotes and check your DateFormat variable to match this date.

Regards

Marco

Tue, 25 Jul 2017 04:57:16 GMT

How can i obtain the date difference of today and a set of data with format like 6/18/2017 12:00:00 AM

Anil_Babu_Samineni — Tue, 25 Jul 2017 07:13:11 GMT

May be use

TimeStamp(DateField) - Now() as Days

Tue, 25 Jul 2017 07:24:02 GMT

It shows an expression error of the wording "as Days"

Kushal_Chawda — Tue, 25 Jul 2017 07:28:42 GMT

try below

floor(Date1) - floor(Date1) as Days

mangalsk — Tue, 25 Jul 2017 07:56:23 GMT

For eg. try below so that you can check exat value, replace Date('7/24/2017 12:00:00 AM') with your required filed name

= Now()-Date('7/24/2017 12:00:00 AM')