topic Re: Date variable misbehaving in QlikView

Date variable misbehaving

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all could you kindly help me assist, I do not have any idea whats going on with my variable. I have set it to the following

vprvdayop = date(today()-1,'YYYYMMDD')

However it returns two days before. Is it a issue with our server at work?? I have just tried in a local file not on the server at it returns the correct day

Re: Date variable misbehaving

migueldelval — Fri, 29 Jul 2016 11:11:43 GMT

Hi brucewhanya,

Try to put on your server today() and check.

Are your server at the same place than you?

Regards

Miguel del Valle

Re: Date variable misbehaving

antoniotiman — Fri, 29 Jul 2016 11:19:17 GMT

Hi,

default for Today() function is Today(2) (date at Open Doc)

May be this is issue.

Regards,

Antonio

Re: Date variable misbehaving

Anil_Babu_Samineni — Fri, 29 Jul 2016 11:52:20 GMT

Your Expression Looks good, My system Today's date 29th Check the Attachment i got the 28th

Re: Date variable misbehaving

Anonymous — Fri, 29 Jul 2016 12:09:24 GMT

the server is in a different building but same site

Re: Date variable misbehaving

sunny_talwar — Sun, 31 Jul 2016 19:16:32 GMT

May be try this:

vprvdayop = Date(Today(1)-1,'YYYYMMDD')

Read about the timer mode here: today ‒ QlikView

Re: Date variable misbehaving

karthikoffi27se — Sun, 31 Jul 2016 20:02:26 GMT

Hi Bruce

Try using now function it will extract the system date and time

Try using Now() function

vprvdayop = date(now()-1);

Thanks

Karthik

Re: Date variable misbehaving

Anonymous — Mon, 05 Sep 2016 21:44:55 GMT

hi i found the issue was i left the file overnight loading and it kept the date when it loaded. so i simply closed the application and re-opened