Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

Hi users,

I have used some variables in the front end of the QlikView Application layer.

Hence one of the text boxes on the front end app showed '27th March 2018' after the reload last night as I had used 'floor(today())' as variable definition.

Today is 28th March 2018 and when I open the App file, will the text box automatically show '28th or 27th March 2018' without me reloading the file again??

4 Replies
sunny_talwar

I think Today() will show 27th March 2018, but Today(1) will show 28th March 2018

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFun...

sunny_talwar

My bad, Today() and Today(1) will show 28th March 2018... but Today(0) will show 27th March 2018

olivierrobin
Specialist III
Specialist III

hello

extracted from qv documentation

The time functions e.g. Now() and Today() will be evaluated whenever a recalculation is required.

Especially the Now() function can become quite costly since it causes a recalculation of the application

Anonymous
Not applicable
Author

Hi,


Try the below one.


Date(Now(),'DD/MMM/YYYY')


Thanks,

Venkata Sreekanth