Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
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