2 Replies Latest reply: Mar 6, 2017 3:29 PM by Stefan Wühl RSS

    How can I extract Date and Time from Timestamp?

    Elise Reiter

      Hello,

       

      Attached is the format of the data in Excel:

       

      I need to Extract Date and Time as separate fields.

       

      I used this:

      Timestamp("Changed Time Stamp",'D/MM/YYYY hh:mm:ss TT')

       

      But am still not able to pull out date separately.

       

      What can I use to get Date as its own and Time as its own?