Jmp version: JMP 17.2.0
I have set in Windows Specific settings for JMP to use the system locale (checked and defintely UK). Restarting software or PC does not result in that locale choice being respected when date-formatted data is imported from Excel.
The data is formatted in Excel as custom:dd/mm/yyyy hh:mm, but upon importing it defaults to m/d/y. If I change the format in excel to be even more explicit and use date:dd/mm/yyyy then it still imports as m/d/y.
I have seen vaguely similar posts in the past asking for default datetime formatting options, which JMP 16 supposedly addressed in part by respecting Excel date formats. I skipped straight to JMP 17 from JMP 15 so not sure if it worked correctly there, but it certainly doens't seem to work in JMP 17 (or at least my installation).
I would be very grateful if someone could please point out what might be the issue here.
