Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
justinposcom
Contributor
Contributor

Today() returning yesterday - Timezone issue

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

Labels (1)
1 Solution

Accepted Solutions
Almen
Creator II
Creator II

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

View solution in original post

11 Replies
sunny_talwar

Check if Today(1) works

justinposcom
Contributor
Contributor
Author

It doesn’t sorry. Still retuned yesterday’s date
Almen
Creator II
Creator II

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

justinposcom
Contributor
Contributor
Author

Thanks Almen,

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

Where is the timezone set in QlikSense?
justinposcom
Contributor
Contributor
Author

Thanks Almen,

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

Is this able to be changed in QlikSense?

Almen
Creator II
Creator II

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

justinposcom
Contributor
Contributor
Author

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
Creator II
Creator II

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
Contributor
Contributor
Author

Thanks very much!