topic Re: Simple Date Calculation proving not so simple.......... in QlikView

Simple Date Calculation proving not so simple..........

prees959 — Sat, 16 Nov 2024 21:48:11 GMT

Hi,

I simply need to calculate the number of days between today and 01/06/2018...... but whatever I try doesnt seem to want to work......

anyone able to assist with this most simple of expressions??

DATES!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Phil

sunny_talwar — Thu, 29 Nov 2018 16:50:23 GMT

Are you dates read as a date field? If they are, you can just do this

Today() - DateField

If they are not, you can do this as a hack (suggest to fix them in the script)

Today() - Date#(DateField, 'MM/DD/YYYY')

Marco — Thu, 29 Nov 2018 16:35:26 GMT

=today() - makedate(2018,6,1)

prees959 — Thu, 29 Nov 2018 16:48:14 GMT

Great Thanks!