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

    How can I extract Date and Time from Timestamp?



      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?