Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
brucewhanya
Contributor III
Contributor III

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

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)
brucewhanya
Contributor III
Contributor III

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

brucewhanya
Contributor III
Contributor III

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