This content has been marked as final. Show 2 replies
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?