topic Re: ISO 8601 timedefinition summer winter time in QlikView

ISO 8601 timedefinition summer winter time

Tue, 10 Oct 2017 08:09:59 GMT

We need to have a good formula to show the time in the iso 8601 format

YYYY-MM-DDThh:mm:ss+02:00

We are now in Summertime Amsterdam +02:00

we go tho wintertime in october and then we need +01:00

We tried different formula, but non is working.

ConvertToLocalTime

Timezone

This formula give problems in the night at 01:00 + 00:00 hour.

hour(now()) = 0 and hour(ConvertToLocalTime(UTC(),'UTC') (local time when reloading the document)

Any suggestions ?

Qlikview version 12

marcus_sommer — Tue, 10 Oct 2017 10:46:51 GMT

Maybe something like this may hint for a solution:

ConvertToLocalTime(UTC() + daylightsaving(),'Amsterdam')

- Marcus

Tue, 10 Oct 2017 11:30:46 GMT

Hi Marcus, thanks for helping

for some reaon daylightsavings and also timezone keeps giving 1:00 in stead of the current 2:00

any ideas ?

swuehl — Tue, 10 Oct 2017 11:34:06 GMT

I think you need to add Daylightsavings() to Timezone() [latter will return timezone without DST]:

=Interval(Rangesum(TimeZone(),DaylightSaving()),'hh:mm')

edit:

And the correct timezone & DST setting needs to be set in OS

marcus_sommer — Tue, 10 Oct 2017 12:05:43 GMT

It looked that these expression worked:

ConvertToLocalTime(timestamp,'Amsterdam', true())

If not you could play with it in the attached application.

- Marcus

Tue, 10 Oct 2017 14:10:32 GMT

many thanks this formula works