2 Replies Latest reply: Jun 22, 2015 7:47 AM by reshma paturi RSS

    Timestamp Conversion

      Hi

       

        

      Submited ByCreatedDateTime
      1270391: S,Sreenath - 09/04/2015 11:42:16 PM# 09/04/2015 11:42:16 PM
      SYSTEM - 01/04/2015 01:03:40 PM# 01/04/2015 01:03:40 PM
      SYSTEM - 01/04/2015 01:13:27 PM# 01/04/2015 01:13:27 PM
      SYSTEM - 01/04/2015 01:28:51 PM# 01/04/2015 01:28:51 PM
      SYSTEM - 01/04/2015 01:37:25 PM# 01/04/2015 01:37:25 PM
      SYSTEM - 01/04/2015 01:46:16 PM# 01/04/2015 01:46:16 PM
      SYSTEM - 01/04/2015 01:49:07 PM# 01/04/2015 01:49:07 PM

      Submited by is the Source data. From the source data am creating createdDateTime by using

      Left([Submited By],7)as Created_ID,

           time#(TextBetween([Submited By],'-','#'),'YYYY-MM-DD hh:mm:ss')as CreatedDateTime,

       

      Now i have to convert the submited by to 24 Hours Time format.

       

       

       

      Thanks