How to get the current date in Qlikview

[#1]

Hello,

Can you please tell me the function which returns the current date in Qlikview.

Thanks

[tresesco]

Date(Now())

[swuehl]

today(timermode)

Please check the Help for the available timer modes:

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.

[#4]

use now() function

[israrkhan]

use now() for date time seceonds.

and today() for today date...

[jagan]

Hi Viju,

Use

Today() for date and

Now() for getting Date and Time.

Hope this helps you.

Regards,

Jagan.

[#7]

in text object write

=today()

[#8]

Hi,

Using Today() function you will get only the Today Date. If you want with the timestamp use Now() Function.

Regards,

Santhosh G

[qv_testing]

Hi,

Now()::   11/14/2013 5:43:51PM

Today(): 11/14/2013

[Anonymous]

You need to be mindful here. When you make use of Now() there is a continuous request of date & time from the system. So try avoiding Now if you do not need current time. When you use today() make sure you pass parameter 1 [Ex: today(1)] to avoid picking document open date and get current date.