Discussion Board for collaboration on QlikView Scripting.
We need to have a good formula to show the time in the iso 8601 format
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.
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
Go to Solution.
I think you need to add Daylightsavings() to Timezone() [latter will return timezone without DST]:
And the correct timezone & DST setting needs to be set in OS
Maybe something like this may hint for a solution:
ConvertToLocalTime(UTC() + daylightsaving(),'Amsterdam')
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 ?
It looked that these expression worked:
If not you could play with it in the attached application.
many thanks this formula works