Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
komminenianusha
Partner - Contributor III
Partner - Contributor III

Issue with Today() function

Hi All,

I am working on Qlikview to qliksense migration. I am facing issue with today(). In qlikview scripting they created one variable with expression as Num(Today()) . So it has to display today date but it is showing 21st Aug 2018 instead of 23rd aug 2018.

I copied this variable in qliksense here it is showing 22nd Aug 2018 instead of 23rd aug 2018. Please help me any one for resolving this.

Even the system date also 23rd aug 2018.

Thanks in advance

Regards,

Anusha

3 Replies
JustinDallas
Specialist III
Specialist III

When was the last time the script was reloaded?  What happens when you use a KPI object with the measure of "Date(Today(),'MM/DD/YYYY')"?

balabhaskarqlik

Today( 0) - Returns the day of the last finished data load.

Today( 1) - When used in a chart expression, this returns the day of the function call.

        When used in a load script, this returns the day when the current data load started.

Today( 2) - Returns the day when the document was opened.

May be use: Num(Today(2)) - Returns the day, when the document was opened.

komminenianusha
Partner - Contributor III
Partner - Contributor III
Author

In KPI object it is showing exact today date.