This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Created:
Sep 9, 2020 04:51 AM
| Last Modified: Jun 10, 2023 07:18 PM(1028 views)
Hello everybody,
how can I change the fefault setting for date and time format when importing from Excel.
I do have the followinf Problem:
Excel Format: DD MM YYYY hh:mm:ss
after importing to JMP it just shows: MM DD YYYY
I know how to change the format in JMP by right-clicking the column. But is there any opportunity to change the default setting for this kind of issue?
Unfortunately, no there is no default setting for this. You'll have to change the column format manually.
I realize it doesn't help you now, but starting in JMP16 dates imported from Excel will appear in JMP just like they do in Excel. (So your date would still be DD MM YYYY hh:mm:ss in JMP.) This is part of a larger date formatting overhaul coming in JMP16.
Unfortunately, no there is no default setting for this. You'll have to change the column format manually.
I realize it doesn't help you now, but starting in JMP16 dates imported from Excel will appear in JMP just like they do in Excel. (So your date would still be DD MM YYYY hh:mm:ss in JMP.) This is part of a larger date formatting overhaul coming in JMP16.
I've also had this issue with date formatting, and the issue is still present in jmp 17.
In excel I have a date column with date format YYYY-MM-DD, but when I use the excel jmp toolbar to generate a jmp Data Table the date column is reformatted to MM-DD-YYYY. This is frustrating and I expected this to be fixed already in jmp 16 after the answer I saw here.
