Here is one way to handle it
Names Default To Here( 1 );
dt = New Table( "Example",
Add Rows( 2 ),
New Column( "datetime",
Character,
"Nominal",
Set Values( {"2023-05-10 17:47:36.005390800+00:00", "6/6/2024 9:06"} ),
Set Display Width( 230 )
)
);
New Column( "new datetime", Numeric, "Continuous", Format( "m/d/y h:m:s", 23, 0 ) );
For Each Row(
If( contains(:datetime, "+"),
theDateTime = word(1,:datetime,"+");
substitute into(theDateTime," ","T");
:new datetime = informat(theDateTime,"yyyy-mm-ddThh:mm:ss");
,
contains(:datetime,"/"),
:new datetime = informat(:datetime,"m/d/y h:m")
)
);
Jim