topic Re: Difference between today's date and a date field in QlikView

Difference between today's date and a date field

Fri, 07 Apr 2017 06:05:39 GMT

Hi,

How do I proceed to get the difference between the dates stored in ProjectLiveDate and the current date so that the difference will be in days.

Example: If ProjectLiveDate is 3/27/2017 in M/D/YYYY format

and today's date is 4/7/2017 in M/D/YYYY format

the difference will be 11 days

Thanks

sunny_talwar — Fri, 07 Apr 2017 08:04:54 GMT

If the dates are read as dates, you can just do this

Today(1) - ProjectLiveDate

If for some reason, QlikView doesn't understand your date, then this

Today(1) - Date#(ProjectLiveDate, 'M/D/YYYY')

tresB — Fri, 07 Apr 2017 08:24:51 GMT

And if you have time stamp for hour/min/sec, you might try with interval() like:

Interval(Today(1) - Date#(ProjectLiveDate, 'M/D/YYYY') , 'D') as DayDiff

Sun, 09 Apr 2017 11:17:59 GMT

Thanks stalwar1‌ and tresesco‌, saw your answers now. I tried

DATEDIFF(DAY,ProjectLiveDate,GETDATE()) as LiveDate

and it worked at my end.