Date-Time Formats

Question

I have date-time data in a column of form:

2020-04-30T17:29:48.967-04:00

This data was loaded from a database.  JMP recognizes it only as a string of characters.

How can I convert this into a JMP datetime format?

P.S. I do not care about the timezone (-04:00).

txnelson · Accepted Answer

Here is a little script that should convert the column to a JMP date time value

names default to here(1);
dt=current data table();
for each row(
	:date = substr(:date, 1, length(:date)-length(word(-1,:date,"-"))-1);
);

dt:date << data type(numeric)<<modeling type(continuous);
dt:date << format("yyyy-mm-ddThh:mm:ss");

Just replace the values of :Date to whatever your column name is