Multiple date formats in one column

[#1]

Hi,

I have imported an excel data table into jmp and in a column that includes date and time, I can see that multiple date and time formats are represented. For that reason, jmp displays this as character. How do I take into account the different formats and still transform this into a date&time format in jmp? According to what I can see, I have two different formats e.g.:

•  2/19/2024 10:46
• 08-03-2022 12:50

Any sugestions on how to approach this?

Br Julie

[#2]

As long as the data "looks" like a date to JMP, simply changing the column to numeric, continuous and the format to your preferred date format works.  I tried it with your example formats, and the conversion was perfect.  I also did it with a simple script.

:Date << Data Type("Numeric")<<Modeling Type("Continuous") << Format( "m/d/y h:m" );