Data time format while importing excel sheet

[#1]

Hello JMP users,

I am trying to import an excel sheet which have two different type date-time format. (screenshot attached below)

chandankishor66_0-1691495406224.png

After importing in JMP format looks like below:

chandankishor66_2-1691495699638.png

Can you suggest how to fix date-time format while importing excel sheet in to JMP table.

Thanks,

[#2]

I would import the column as a character string, and then create a new formula column where the formula uses the distinction between the rows where the column has "/" vs. "-" to use the 2 different Informats, to input the two different date structures.

[#3]

I concur with @txnelson.

Afterward, you can also check this discussion

 https://community.jmp.com/t5/Discussions/Convert-Date-after-Import-file-from-Excel-Issue/m-p/653497