Date imported from Excel in 1904

Elofar1 — Thu, 02 Nov 2023 13:14:26 GMT

Hello Community!

I am trying to do a script to automatically import an Excel file and create some graphs. I have a file with a column of date (dd Mon yyyy) which is important as it will be my X axis (Excel file attached).

If I go directly from the Excel file to JMP using the add-on button, it’s working perfectly well, I get my datatable with my Date column properly formatted.

But I want to script it using the Workflow (I'm using JMP17 on Windows), so I'd like to go from JMP, Open the wizard and open my file. But then, my dates are imported as Numbers (44937), and if I change the attributes to get a date, I only have 1904 ...

How could I script the data treatment of this column?

Re: Date imported from Excel in 1904

Jed_Campbell — Thu, 02 Nov 2023 14:00:29 GMT

Would something like this work? The attached workflow assumes the Excel file is on your desktop.

topic Date imported from Excel in 1904 in Discussions

Date imported from Excel in 1904

Re: Date imported from Excel in 1904