topic Re: doubt on today in QlikView

doubt on today

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In text object,

I take

Now(), it returns sys date(5/19/2016) along with time stamp.It's fine

But If I take

Today(), it shows different date (5/16/2016)

why it not considering today's(sys) date?

Also In QVW, date is same but time is different.

How do we change into standard date with time stamp?

Please clarify this in detail.

Below attached for your reference.

sunny_talwar — Thu, 19 May 2016 13:02:31 GMT

Try Today(1)

UPDATE: Read about the different today modes here:

Thu, 19 May 2016 13:17:40 GMT

Thanks Sunny !!

Then what about application date?

System and application dates both are different

is it possible to change in application ??

Thu, 19 May 2016 13:31:48 GMT

it is working for me.

check your system once.

attached is my output for your reference

sunny_talwar — Thu, 19 May 2016 13:58:34 GMT

Change what exactly?

Anil_Babu_Samineni — Thu, 19 May 2016 15:08:21 GMT

Working Fine....

rwunderlich — Thu, 19 May 2016 15:56:38 GMT

The default timer mode is "2", which is the date the document was opened. So it looks like your doc has been opened for several days.

-Rob