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:4608-03-202...