topic Re: Data time format while importing excel sheet in Discussions

Data time format while importing excel sheet

chandankishor66 — Tue, 08 Aug 2023 11:56:10 GMT

Hello JMP users,

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

After importing in JMP format looks like below:

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

Thanks,

Re: Data time format while importing excel sheet

txnelson — Tue, 08 Aug 2023 12:15:14 GMT

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.

Re: Data time format while importing excel sheet

WebDesignesCrow — Wed, 09 Aug 2023 01:47:02 GMT

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