topic Re: Today function returning yesterday in QlikView

Today function returning yesterday

Anonymous — Tue, 25 Mar 2014 14:37:15 GMT

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?

Re: Today function returning yesterday

Greg_Williams — Tue, 25 Mar 2014 14:38:09 GMT

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

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

Re: Today function returning yesterday

Tue, 25 Mar 2014 14:38:39 GMT

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.

Re: Today function returning yesterday

Anonymous — Tue, 25 Mar 2014 14:39:05 GMT

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.

Re: Today function returning yesterday

its_anandrjs — Tue, 25 Mar 2014 14:42:18 GMT

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

Re: Today function returning yesterday

MK_QSL — Tue, 25 Mar 2014 15:06:47 GMT

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.

Re: Today function returning yesterday

Anonymous — Wed, 28 Feb 2018 16:29:39 GMT

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

Re: Today function returning yesterday

sohailansari201 — Tue, 17 Jul 2018 21:42:18 GMT

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.

Re: Today function returning yesterday

a_jimenez — Sat, 20 Jul 2019 01:21:54 GMT

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