551788_en-US

liliconcom

Dealing with two type of date format

Hello JMP users,

I have a Date column with have two types of format .

1. Numeric format 

2. DD:MM:YY format.

How to convert the whole colum into DD:MM:YY

Whenever I tried to change the data type and modeling type of this column, it could not change the format for whole column.

       

 

      

 

Any suggestions would be highly appreciated.

Regards.

 

 

 

 

ScriptingRe: Dealing with two type of date format

Here is a script that will make the change

names default to here(1);
dt=current data table();
for each row(
 if(contains(:Date 2, "-" ) == 0,
  :Date 2 = format(num(:Date 2),"d/m/y")
 )
);
:Date 2 << data type(numeric)<<INFORMAT></INFORMAT>