topic Re: Today() in QlikView

Today()

tyagishaila — Fri, 12 Dec 2014 08:42:19 GMT

Is there any difference between

LET vTodayDate=Today(Date);

and

LET vTodayDate=Today();

where Date is a dimension in table,

Re: Today()

yduval75 — Fri, 12 Dec 2014 08:43:46 GMT

Today(Date) will not work

You can just use today() function

Re: Today()

jyothish8807 — Fri, 12 Dec 2014 08:46:44 GMT

Hi Sahil,

Today(Date) will not work instead of that try max(Date).

Regards

Re: Today()

Anonymous — Fri, 12 Dec 2014 08:57:40 GMT

Use peek. Like

let vToday = peek('Date');

Serhan

Re: Today()

tyagishaila — Fri, 12 Dec 2014 08:59:18 GMT

But Its working in my script,

LET vTodayDate= Today();

gives me o/p on Text Object 12/11/2014

and

LET vTodayDate=Today(Date);

gives o/p 12/12/2014

which is right.

Why it happens I don't know

Re: Today()

tyagishaila — Fri, 12 Dec 2014 09:04:05 GMT

But

why Let vTodayDate = Today();

is not giving correct o/p.

Its giving 12/11/2014

Re: Today()

arulsettu — Fri, 12 Dec 2014 09:07:28 GMT

hi try

=Date(Today())

Re: Today()

Anonymous — Fri, 12 Dec 2014 09:10:19 GMT

Hello,

Today() can take parameters. Not the date though. From QlikView Help:

Today()

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()

tresB — Fri, 12 Dec 2014 09:15:20 GMT

Today() allows an argument which indicates [timer mode].

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.

When you pass an argument which is not any of these three(0,1,2), it would probably take the default value 2. Eventually here both return same output for you. Hope that makes sense.