Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using the today() function but for the first half of the day it is retuning yesterdays date. Could it be a timezone issue? Is there a way to change to GMT+10 so today returns todays date from 12.00am each day
Thanks for your help
Check with timezone() if Qlik is using GMT+10. It depends on the timezone set on your Qlik Server.
Check if Today(1) works
Check with timezone() if Qlik is using GMT+10. It depends on the timezone set on your Qlik Server.
Thanks Almen,
timezone() is returning GMT. I need it to be GMT +10:00.
Is this able to be changed in QlikSense?
Try ConvertToLocalTime(NOW(), 'GMT+10:00')
You could move that expression into a variable for easier usage.
If you want to change the timezone of Qlik I think it might work if you change the timezone of the server on which qlik is hosted for you.