User Community
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: 
  • DownloadSemiconductor Toolkit: Tools to create wafer maps, add wafer geometry to graphics, explore die defects & compare wafers.
  • Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
  • Use JMP Clinical with CDISC-compliant data. Review studies, ID safety and efficacy signals & communicate findings with interactive graphics. Register to see how. Aug. 27, 2 pm US ET.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Mickyboy
Mickyboy
Level V

Dates When Importing Data from an Excel Spreadsheet

Sep 14, 2018 01:38 AM (8242 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 (8221 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 (8222 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

Recommended Articles