topic Re: "Today' date" cached? in QlikView

"Today' date" cached?

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

I have a variable that determines today's date. Nothing strange about that.

However, I have noticed that it isn't always showing today's date, but rather yesterday's date. I have my theories. Could it be that I kept my Qlikview application open over night, and just put the computer in sleep mode over night, and then Qlikview caches the previous date somehow? When I restarted my computer (of course also closing the QV application down), and reloaded, it showed the correct "today's" date.

What is the most likely problem? Keeping Qlikview open over night or not restarting my computer?

Thanks

Re: "Today' date" cached?

Vegar — Tue, 04 Jun 2019 08:03:17 GMT

You are correct Mathias, it's caused by you leaving the application open.

You can run today() with a parameter, like Today(0), today(1) or today(2). If you don't type an parameter then the default is 2.

0 (day of last finished data load)
1 (day of function call)
2 (day when the document was opened)

Re: "Today' date" cached?

kkkumar82 — Tue, 04 Jun 2019 10:40:12 GMT

As Vegar said better to use Today(1) to get the current system date

Re: "Today' date" cached?

MEJ — Tue, 04 Jun 2019 10:59:05 GMT

Thanks. Good job!