5 Replies Latest reply: Apr 17, 2018 2:02 PM by Patric Amatulli RSS

    Date Format DD.MM.YY to DD.MM.YYYY

    Patric Amatulli

      Hi guys,

       

      I have an issue when I am loading thd data from the source System (Oracle).

       

      All dates and timestamp format are delivered with the YY Format for the year.

      When trying to change the format in Qlikview to DD.MM.YYYY the data are interpret wrong:

       

      e.g. 07.03.10 13;04:00 to 07.03.0110

       

      Should be => 07.03.2010 ...

       

      What I can do to adjust it to the right format?

       

      Thanks,

      Patric