Dealing with two type of date format

chandankishor66 — Fri, 09 Jun 2023 15:59:33 GMT

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.

Re: Dealing with two type of date format

txnelson — Mon, 03 Oct 2022 12:51:59 GMT

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");

topic Dealing with two type of date format in Discussions

Dealing with two type of date format

Re: Dealing with two type of date format