12 Replies Latest reply: May 18, 2017 9:18 PM by Rakesh Shah RSS

    Corruption Importing date format

    Rakesh Shah

      Hi All

       

      I am having issues importing from a CSV file - when I use the date# and date functions on load it appears to be modifying the date's month.

      First Image is the original file opened in Notepad++ - i have highlighted the bit in questions - clearly a February Month

      Second image is the import line i have in Qlik

      Third image is the resulting field in Qlik sheet - changed to December

       

      if it helps I am running the latest version of Qlik Sense Desktop 3.2 SR2 (10.18.3)

       

      Looking for help with what im doing wrong

       

      Thanks

      Rakesh

       

       

      Image1.PNGimage2.PNGImage3.PNG