This content has been marked as final. Show 5 replies
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