BookmarkSubscribeRSS Feed
Highlighted
Mickyboy

Contributor

Joined:

Jun 17, 2018

Dates When Importing Data from an Excel Spreadsheet

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???

1 ACCEPTED SOLUTION

Accepted Solutions
briancorcoran

Joined:

Jun 23, 2011

Solution

Re: Dates When Importing Data from an Excel Spreadsheet

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

1 REPLY
briancorcoran

Joined:

Jun 23, 2011

Solution

Re: Dates When Importing Data from an Excel Spreadsheet

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