6 Replies Latest reply: Nov 7, 2017 4:01 AM by Shraddha Gajare RSS

    Date format from CSV

    Wai Meng Leong

      Hi community,


      I have a problem with a date field (maybe it isn't even processed as a Date field when loaded in Qlik.)

      This is the csv view of the field.



      So I am trying to get the Month and Year from this field and I have tried all the following in load script (because the field just doesn't read as a date field.


      This is what I see in the dashboard view:


      Lastly, here's the SETTINGS (I have tried a few date formats)


      Would greatly appreciate any help! Thank you in advance.



      Wai Meng