topic Re: Today function shows old date in QlikView

Today function shows old date

Wed, 23 Dec 2015 15:26:36 GMT

Hi,

I have a dashboard and have today() function for comparing Order Date. I opened dashboard two days back and didn't close it but when I refreshed the dashboard still my today function is taking two days before date, not sure why it is happening like that.

Any suggestions.

Thanks,

Re: Today function shows old date

lironbaram — Wed, 23 Dec 2015 15:29:14 GMT

today() function return the that of last data load

for more details look at this

QlikView ‒ today - script and chart function

Re: Today function shows old date

sunny_talwar — Wed, 23 Dec 2015 15:29:43 GMT

Are you using QV12?

UPDATE: Check if Today(1) makes any difference

Re: Today function shows old date

MK_QSL — Wed, 23 Dec 2015 15:31:47 GMT

Today() is having mode 0 by default which will show date at the time of script run

Today(1) will give date at function call

Today(2) will give date when the document was opened.

Re: Today function shows old date

Wed, 23 Dec 2015 15:33:00 GMT

Then not sure what is the use of today function. then what should I use if I want to get the current date.

Thanks,

Re: Today function shows old date

sunny_talwar — Wed, 23 Dec 2015 15:34:42 GMT

Like Manish pointed out, try Today(1)