cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Mickyboy
Mickyboy
Level V

Dates When Importing Data from an Excel Spreadsheet

Sep 14, 2018 01:38 AM (6881 views)

Hi All,

 

l am importing excel spreadsheets into JMP using file open,  in excel the date is in Australian format of DD/MM/YYYY, JMP will only import when the date can also be interpreted as   American date format, for example, it will import 08/02/2018 as it could be 08/02/2018 or 02/08/2018, but it will not import 26/03/2018, which can be only 26/03/2018, i have tried changing the format in excel to a fixed date format (not sensitive to local settings), but this hasnt worked, does anyone else have any ideas???

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Dates When Importing Data from an Excel Spreadsheet

Sep 14, 2018 09:22 AM (6860 views)  |  Posted in reply to message from Mickyboy 09-14-2018

Hi,

 

You don't mention which version of JMP you are using.  Time processing has changed and improved with each release.  The particular time you mention can cause issues.  However, if you have JMP 13 or 14 and you explicitly type the column in Excel, JMP should honor that format.  You must highlight the entire column within the Excel worksheet, and type it as dd/mm/yyyy.  Save it out, and then import it into JMP to get the desired result.

 

Brian Corcoran

JMP Development

View solution in original post

1 REPLY 1
briancorcoran
Staff briancorcoran
Staff
Solution

Re: Dates When Importing Data from an Excel Spreadsheet

Sep 14, 2018 09:22 AM (6861 views)  |  Posted in reply to message from Mickyboy 09-14-2018

Hi,

 

You don't mention which version of JMP you are using.  Time processing has changed and improved with each release.  The particular time you mention can cause issues.  However, if you have JMP 13 or 14 and you explicitly type the column in Excel, JMP should honor that format.  You must highlight the entire column within the Excel worksheet, and type it as dd/mm/yyyy.  Save it out, and then import it into JMP to get the desired result.

 

Brian Corcoran

JMP Development