topic Re: Date time stamp form excel failed in Discussions

Date time stamp form excel failed

Mike_S — Tue, 25 Feb 2025 10:42:24 GMT

Value original Excelfile format date-time: 17.09.2021 10:37:24
Value after JMP-Import type STRING: 44439,1151041667

Value JMP after correcting the type to date/time: 01.01.1904 12:20

That's a big problem and up to now I haven't found a solution. There are several columns with same issue.
It would be graet if somebody has a solution or tip.

Re: Date time stamp form excel failed

Mike_S — Tue, 25 Feb 2025 10:46:59 GMT

Remark: During the JMP import all date-time columns are show correct in the preview

Re: Date time stamp form excel failed

Mike_S — Tue, 25 Feb 2025 10:58:09 GMT

That's strange, when I copy the date from the Excel-file and insert them into an empty datas sheet it works proper. So it seems to me like a JMP internal import problem.

Re: Date time stamp form excel failed

Stuart_Little — Tue, 25 Feb 2025 11:18:38 GMT

Hi @Mike_S,

I've tried to replicate this behavior with some simple examples in the attached excel file without success regardless of the import method chosen. To help resolve this one, could you answer the following questions?

1. Can you import the attached file successfully? If you can, could you share a snippet of the time/date column you're having trouble with as an Excel file

2. What version of JMP are you running currently ?

Re: Date time stamp form excel failed

txnelson — Tue, 25 Feb 2025 12:31:08 GMT

I assume that what you are seeing is the internal representation of an Excel date/time. The integer portion of the value is the number of days since 01/01/1900 and the decimal portion is the proportion of the day( .25 is 6AM, .5 is 12 noon etc. ). However, when I take 44439,1151041667 and feed it into Excel, I get 08/31/2021 02:45:45. Is it possible you are showing the values from 2 different cells?

What version of JMP are you using, and what operating system?