Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
jfsilves
Level I

Date-Time Formats

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).

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Date-Time Formats

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

Jim

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

Re: Date-Time Formats

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

Jim

View solution in original post

Article Labels

    There are no labels assigned to this post.