JMP doesn't recognize year from date column when importing Excel to JMP table
I have an Excel worksheet with date column where the date is shown as D-MMM.When I imported this worksheet to JMP using Excel Import Wizard, JMP recognize only D-MMM After I have edited the column format from <D><-><MMM> to be <D><-><MMM><YYYY>, JMP thought that the <YYYY> is 1904 (default year) What should be the better way to fix this? I can only think of two ways currently, not sure if there ar...