topic Re: Time zone issues in QlikView

Time zone issues

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 02:07:36 GMT

Try Today(1) to see what it gives?

today ‒ Qlik Sense

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 03:13:27 GMT

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

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

Re: Time zone issues

jmvilaplanap — Fri, 14 Jul 2017 08:46:35 GMT

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

Check this page today ‒ QlikView‌

Regards

Re: Time zone issues

jmvilaplanap — Fri, 14 Jul 2017 08:48:35 GMT

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

Regards

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 10:56:21 GMT

May be check here:

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

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 14:25:04 GMT

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?

Re: Time zone issues

jmvilaplanap — Fri, 14 Jul 2017 14:45:04 GMT

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

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

Regards

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 14:49:00 GMT

May be this

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

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 15:09:12 GMT

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.

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 15:13:28 GMT

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

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 15:15:32 GMT

Sample attached

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 17:21:22 GMT

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.

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 17:23:49 GMT

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

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 18:18:16 GMT

My system is the 'UTC-06:00'

Qlik is GMT for whatever reason.

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 18:33:02 GMT

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?

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 18:59:03 GMT

I am using Qlik Sense Cloud

Re: Time zone issues

sunny_talwar — Fri, 14 Jul 2017 19:00:31 GMT

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

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 19:04:13 GMT

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

Re: Time zone issues

joshrussin — Fri, 14 Jul 2017 19:52:44 GMT

Why do you use Floor in the second expression?