Importing Excel Files Containing Mixed Date Formats into JMP results in missing values
Hello!
I am currently facing an issue while importing an Excel file that contains a date column into JMP. This column includes two different formats: "DD/MM/YYYY" and "DD/MM/YYYY hh:mm". The "DD/MM/YYYY" format should be interpreted as midnight, i.e., "DD/MM/YYYY 00:00". However, when I import the file into JMP, whether via script or the GUI, whatever import option used, JMP seems to import missing...