Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
JohannesENS
Level II

Default setting for date format

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?

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Default setting for date format

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.

View solution in original post

1 REPLY 1
Highlighted

Re: Default setting for date format

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.

View solution in original post

Article Labels