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

         

      FROM

      [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