Dealing with two type of date format

[#1]

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.

[#2]

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("d/m/y")<< format("d/m/y");