Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
MEJ
Contributor III
Contributor III

"Today' date" cached?

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

 

1 Solution

Accepted Solutions
Vegar
MVP
MVP

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)

View solution in original post

3 Replies
Vegar
MVP
MVP

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)
kkkumar82
Specialist III
Specialist III

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

MEJ
Contributor III
Contributor III
Author

Thanks. Good job!