Change text field to date:time
How can I change this: shipment-date 2017-06-25T04:59:14+00:00 which is now a text field to this: 2017-06-25 04:59:14 as a date/time field What is the formula syntax to do it?
Forum Discussion
Try this
var Date DatePart = Left([shipment-date],"T");
var TimeOfDay TimePart = Right([shipment-date],"T");
ToTimeStamp($DatePart, $TimePart )
var Date DatePart = Left([shipment-date],"T");
var TimeOfDay TimePart = Right([shipment-date],"T");
ToTimeStamp($DatePart, $TimePart )