Solved: Time zone issues - Qlik Community

joshrussin · ‎2017-07-13

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 · ‎2017-07-14

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))

View solution in original post

sunny_talwar · ‎2017-07-13

Try Today(1) to see what it gives?

today ‒ Qlik Sense

joshrussin · ‎2017-07-13

Just putting that into a textbox, still returns as today's date.

Also, LET today = today(1); in the script, nothing as well.

jmvilaplanap · ‎2017-07-14

Hi

If you are using today() without parameters, QV returns the day of the last finished data reload.

Check this page today ‒ QlikView‌

Regards

jmvilaplanap · ‎2017-07-14

To check the timezone of your QSCloud try with this function: Timezone(). It returns a string with the timezone

Regards

sunny_talwar · ‎2017-07-14

May be check here:

how to convert a local time to utc time when I have the time zone?

joshrussin · ‎2017-07-14

If I perform the Timezone() function, it returns GMT

I am on UTC-06:00 where I am.

Is there any way to set the time zone?

jmvilaplanap · ‎2017-07-14

I think is not possible, you will have to convert the dates.

I tried with "CollationLocale" but this doesn't run

Regards

sunny_talwar · ‎2017-07-14

May be this

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

joshrussin · ‎2017-07-14

That shows the current time and date correct. now trying to create a variable for this or if you think there is a way to set that result as the Today() function.

I tried LET TodayMem =ConvertToLocalTime(Now(), 'UTC-06:00')

but when I try to call that variable it returns nothing.