Good evening,
I upgraded from v16.0 to v16.2 of JMP today.
By using an already existing file (under v15, then v16.0), I unfortunately experienced a bug importing the date format (be careful, no error message but I consider this import defect as a bug now ).
I have a script that allows me to retrieve data from an Excel file (xlsx). The Excel file as well as my JMP table are in date format of type dd/mm/yyyy for the date column. But when I import data from Excel to JMP I sometimes end up with a "." black instead of my data = no data or not recognized, or with the date as I expect it in dd/mm/yyyy format.
I tried changing the column property to Best Fit, I end up with the date in the format number=ex:441025, unworkable as it is but proving that the import works and it is indeed 'a date format inconsistency.
Thank you in advance for your help !
Cordially 
Would it be possible to provide a sample Excel file that shows the error?
Hello Nelson, Thank you for your feedback! Here is a light example (because it is confidential) of the Excel file from which the data (including the date) is extracted.
Cordially !
