Time zone issues

[joshrussin]

Hey everyone..

I just logged on to Qlik Sense Cloud and the Today() function is returning tomorrow's date.

It is only 7pm and is already returning tomorrow's date.

I would have to assume the time zone of Qlik is somewhere else.

Is there any way to set the Today function to a local time zone or set it to a specific time zone?

Thanks

[sunny_talwar · Accepted solution]

Try with set and see what happens

SET TodayMem = Num(ConvertToLocalTime(Now(), 'UTC-06:00'))

and then on the front end like this

TimeStamp($(TodayMem))

Or if you just need the date, then this

SET TodayMem = Floor(ConvertToLocalTime(Now(), 'UTC-06:00'))

and this

Date($(TodayMem))

[sunny_talwar]

Sample attached

[joshrussin]

This works!

Do you think there is any way to make today() get this result so I don't have to change the today() in every expression I have.

[sunny_talwar]

I would think that it is based on system date... Is your system date not consistent with Today()?

[joshrussin]

My system is the 'UTC-06:00'

Qlik is GMT for whatever reason.

[sunny_talwar]

Is this a desktop version we are talking about or on access point? If it is server, then the server could be GMT may be?

[joshrussin]

I am using Qlik Sense Cloud

[sunny_talwar]

Don't really know how cloud works, but it could be that the server might be in GMT location... don't really know

[joshrussin]

alright, well i'll just create a variable that converts it and just use that as my "today()", so to speak.

[joshrussin]

Why do you use Floor in the second expression?