4 Replies Latest reply on Nov 12, 2016 9:28 PM by Mahfooj Khan

    Hi friends, I am looking to split (or by using calculated fileld) a coulmn named "time" into two separate or different columns like "date" and "time"

    naveen kumar

      Hi please have a look at the below image for reference.

      I need to have two columns from this column  "Time"

      I would like to have few columns like "Date" which gives me only date as 2016-08-01 (format is yyyy-mm-dd), "Time" which gives only time 00:00:000 (format is hh:mm:sec or may be just hh:mm is enough)

       

      This is the data what I get for every 10 minutes.