Today() returning yesterday - Timezone issue

[justinposcom]

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

[sunny_talwar]

Check if Today(1) works

[justinposcom]

It doesn’t sorry. Still retuned yesterday’s date

[Almen · Accepted solution]

Check with timezone() if Qlik is using GMT+10. It depends on the timezone set on your Qlik Server. 

[justinposcom]

Thanks Almen,

Timezone says GMT and I need it to be GMT +10:00

Where is the timezone set in QlikSense?

[justinposcom]

Thanks Almen,

timezone() is returning GMT. I need it to be GMT +10:00.

Is this able to be changed in QlikSense?

[Almen]

Try ConvertToLocalTime(NOW(), 'GMT+10:00')

[justinposcom]

Does that have to be used in every formula or is there a way to set Timezone so today() always uses that new timezone?

[Almen]

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.

[justinposcom]

Thanks very much!