topic No. Days Difference in QlikView

No. Days Difference

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to get the number of days between today and different dates.

I use the following expression:

=INTERVAL(DATE(TODAY())-DATE_TIME_TRANSACTION,'DD')

(The field DATE_TIME_TRANSACTION has this format: DD/MM/YYYY hh:mm:ss)

The problem is that when I have transactions from today, it returns me the value -1.

Do you know how could I solve this?

Thank you!

jduenyas — Wed, 16 May 2018 19:36:59 GMT

INTERVAl takes only one parameter and compares against system's date.

Difference between dates:

Today() - [other date]

Example: Today()-Date('5/1/2018')

sunny_talwar — Wed, 16 May 2018 19:37:28 GMT

May be this

=Today() - Floor(DATE_TIME_TRANSACTION)

shiveshsingh — Thu, 17 May 2018 05:00:02 GMT

Try floor as suggested by Sunny , it will work. Floor will omit your time part

Today() - floor(DATE_TIME_TRANSACTION)

Anonymous — Thu, 17 May 2018 07:04:26 GMT

try this

SET TimestampFormat='DD/MM/YYYY hh:mm:ss';

LOAD * ,

Interval(Today()-date,'dd' )as count

INLINE [

date

01/05/2018 08:40:45

02/05/2018 08:40:45

];

vishalarote — Thu, 17 May 2018 07:22:13 GMT

FLOOR(NUM(now()-date)) as Count