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
re: Any idea what this is?
yes: Sloppiness on my part :)
OK, let's try that again
Try this
var Date DatePart = ToDate(Left([shipment-date],"T"));
var TimeOfDay TimePart = ToTimeOfDay(Right([shipment-date],"T"));
ToTimeStamp($DatePart, $TimePart )
yes: Sloppiness on my part :)
OK, let's try that again
Try this
var Date DatePart = ToDate(Left([shipment-date],"T"));
var TimeOfDay TimePart = ToTimeOfDay(Right([shipment-date],"T"));
ToTimeStamp($DatePart, $TimePart )