11 Replies Latest reply: Dec 18, 2014 10:10 PM by Jyothish KC RSS

    Formatting DATE Field (YYYY-MM-DD :hh:mm:SS) into two separate fields Date (yyyy-mm-dd) and time (hh:mm:ss)??

      Dear community users


      Can anyone suggest how do i format my Date field which is originally in this format (YYYY-MM-DD:hh:mm:SS) into two separate list boxes named Date and time?


      my script is:

      LOAD @1 as Country,


           @5 as DATE,

           @6 as Duration,


           @11 as Technology



      [D:\Users\d322797\Documents\QlikView\ravi 20141218.txt]

      (txt, codepage is 1252, no labels, delimiter is ',', msq);


      Screen Shot 12-18-14 at 01.15 PM 001.JPG