[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: ISO-DATE convert

[Stefan Drissen]

It is an ISO 8601 date-time, which is indeed what json uses. One easy way to convert it back is to use what's already available in the Json classes: USING Progress.Json.ObjectModel.JsonObject. def var ojson as JsonObject no-undo. def var dt as datetime-tz no-undo. ojson = new JsonObject(). ojson:add( "iso", "2020-03-12T12:43:11.518+01:00" ). message ojson:getdatetimetz( "iso" ) skip ojson:getdatetime( "iso" ) skip ojson:getdate( "iso" ) view-as alert-box.

Continue reading...