Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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
Highlighted

Check if Today(1) works

Highlighted
Contributor
Contributor

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

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

View solution in original post

Highlighted
Contributor
Contributor

Thanks Almen,

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

Where is the timezone set in QlikSense?
Highlighted
Contributor
Contributor

Thanks Almen,

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

Is this able to be changed in QlikSense?

Highlighted
Creator
Creator

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

Highlighted
Contributor
Contributor

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

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.

Highlighted
Contributor
Contributor

Thanks very much!