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

       

       

      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