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
OK, this is tested
var date DatePart = Date(
ToNumber(Left([shipment-date],4)),
ToNumber(Mid([shipment-date],6,2)),
ToNumber(Mid([shipment-date],9,2)));
var TimeOfDay TimePart = ToTimeOfDay(Mid([shipment-date],12,5));
ToTimestamp($DatePart, $TimePart )
var date DatePart = Date(
ToNumber(Left([shipment-date],4)),
ToNumber(Mid([shipment-date],6,2)),
ToNumber(Mid([shipment-date],9,2)));
var TimeOfDay TimePart = ToTimeOfDay(Mid([shipment-date],12,5));
ToTimestamp($DatePart, $TimePart )