Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I have an issue with 29 feb 2016. If I use the function date(today()) it will return the value 29/02/2016. It was like that yesterday (01/03/2016), and still same issue today (02/03/2016).
But I don't have this issue on each computer. Some will return the correct date. Those that return value 29/02/2016 every day have the clock in the bottom right corner with the correct date. Also I check in Excel, and it gives me the right date.
So how does it work in Qlik, why for some computers it date is blocked on 29/02/2016?
Best regards
Standard setting for the today()-function is to return the date when the document was opened. If the document has been open since 29/02/2016, that is the date you will see.
Try to either close and reopen the doc or use Today(0) (for date when script was reloaded) or Today(1) for system date. Do you still see 29/02/2016?
Regards,
Kristofer
Today, with Date(Today()) you are getting 29/02/2016??
This function works on your system or server date kindly check this date it is correct or not. If it is older then it gives old date or vise versa.
Regards,
Anand
please check your machine date it must be 29 feb 2016, and the machine on which u are getting correct date must have date 2 mar 16, it works on your machine date.
hope it helps
Standard setting for the today()-function is to return the date when the document was opened. If the document has been open since 29/02/2016, that is the date you will see.
Try to either close and reopen the doc or use Today(0) (for date when script was reloaded) or Today(1) for system date. Do you still see 29/02/2016?
Regards,
Kristofer
Hi Kristofer,
Indeed those computer were not switch off since the 29/02. So we will change the script by using Today(1).
Thanks for your help.