Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Today function returning yesterday

Hi guys,

Looking on my Qlikview file i got some wrong values. Analising it i got that "=Today()" was returning the date of yesterday. Anyone have some idea?

Tags (2)
8 Replies
Highlighted
Employee
Employee

Re: Today function returning yesterday

What is your computer's date/time? Is that identifying today or tomorrow?

Perhaps adjust to =date(today()+1)

Highlighted
Not applicable

Re: Today function returning yesterday

If the file was reloaded yesterday and not today then it might show yesterday's date. If it was reloaded today and you have this problem maybe you can try using

Now()

ReloadTime()

functions to see what they return.

Highlighted
Contributor

Re: Today function returning yesterday

Refer to this.....

Today() -v- Now()

Today() will show you the day the document was last reloaded. Today(1) will show you the actual day it is today. Now() is a timestamp that is second-per-second as is much heavier.

Hope this helps.

Highlighted

Re: Today function returning yesterday

May be your system date is 1 day old check your system date other wise plot =Now() in any text and then check what date is display.

Hope this helps

Thanks & Regards

Highlighted
MVP
MVP

Re: Today function returning yesterday

today([timer_mode] )

Returns the current date from the system clock. The timer_mode may have the following values:

0 Date at script run
1 Date at function call
2 Date when the document was opened  

Default timer_mode is 2. The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system.

Highlighted
New Contributor III

Re: Today function returning yesterday

You need to save, close and open de document again.

Highlighted
Contributor

Re: Today function returning yesterday

Your QlikView software is open since yesterday. I have also noticed that today() returns the value of the day when QlikView was originally opened and not closed since. For e.g. if I open QlikView software on 1/1/2018 and keep it opened for the next several days, the today() function will still returns the 1/1/2018 as the result. Therefore, just close the QlikView and reopen it and this problem will be fixed.

Highlighted
New Contributor

Re: Today function returning yesterday

Best Explanation for this issue! Clear & Simple. Wish most of the QV responses were as easy to digest as your response.