767886_en-US

liliconcom

Multiple date formats in one column

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

Automation and ScriptingRe: Multiple date formats in one column

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=""></MODELING>