Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date variable misbehaving

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

7 Replies
migueldelval
Specialist
Specialist

Hi brucewhanya,

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

Are your server at the same place than you?

Regards

Miguel del Valle

antoniotiman
Master III
Master III

Hi,

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

May be this is issue.

Regards,

Antonio

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

the server is in a different building but same site

sunny_talwar

May be try this:

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

Read about the timer mode here: today ‒ QlikView

karthikoffi27se
Creator III
Creator III

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

Anonymous
Not applicable
Author

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