topic Re: Today() -v- Now() in QlikView

Today() -v- Now()

Tue, 07 Sep 2010 20:28:17 GMT

when I use Today() function, I get 9/3/2010 and it is 9/7/2010 and my system clock is accurate at 9/7/10

but when i use Date(Now()) i get 9/7/2010

Any ideas on what might cause this?

Today() -v- Now()

vgutkovsky — Tue, 07 Sep 2010 20:38:35 GMT

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.

Today() -v- Now()

johnw — Tue, 07 Sep 2010 21:15:00 GMT

From the help text:

now( [ timer_mode] )

Returns a timestamp of the current time from the system clock. The timer_mode may have the following values:

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

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

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.

So now(), now(1) and today(1) all refresh every second, and should be used with caution.

Re: Today() -v- Now()

Mon, 16 Dec 2013 13:31:48 GMT

You can make a counter regressive time?