Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi brucewhanya,
Try to put on your server today() and check.
Are your server at the same place than you?
Regards
Miguel del Valle
Hi,
default for Today() function is Today(2) (date at Open Doc)
May be this is issue.
Regards,
Antonio
Your Expression Looks good, My system Today's date 29th Check the Attachment i got the 28th
the server is in a different building but same site
May be try this:
vprvdayop = Date(Today(1)-1,'YYYYMMDD')
Read about the timer mode here: today ‒ QlikView
Hi Bruce
Try using now function it will extract the system date and time
Hi
Try using Now() function
vprvdayop = date(now()-1);
Thanks
Karthik
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