5 Replies Latest reply: Oct 10, 2017 10:10 AM by Mireille van der Heiden RSS

    ISO 8601 timedefinition summer winter time

    Mireille van der Heiden

      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