Multiple date formats in one column

JulieSAppel — Mon, 24 Jun 2024 13:26:06 GMT

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

Re: Multiple date formats in one column

mmarchandFSLR — Mon, 24 Jun 2024 14:16:13 GMT

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

topic Multiple date formats in one column in Discussions

Multiple date formats in one column

Re: Multiple date formats in one column