16 Replies Latest reply: Apr 11, 2017 7:40 AM by Sunny Talwar RSS

    Date/Time format issue

    Arpit Kharkia

      Hi all,

       

      I have a timestamp field which consists date of the following two formats:

       

      • MM-DD-YYYY HH:MM
      • MM/DD/YYYY HH:MM:SS TT

       

      I want to extract date and time separately in the following formats:

       

      • MM-DD-YYYY
      • HH:MM:SS

       

      Thanks in advance!