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]

Try Today(1) to see what it gives?

today ‒ Qlik Sense

[joshrussin]

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

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

[jmvilaplanap]

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]

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

Regards

[sunny_talwar]

May be check here:

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

[joshrussin]

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]

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

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

Regards

[sunny_talwar]

May be this

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

[joshrussin]

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.