cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

JMP Wish List

We want to hear your ideas for improving JMP. Share them here.
Choose Language Hide Translation Bar
0 Kudos

Simplifying Date Column Format

What inspired this wish list request? 

I was sidelined for about an hour, trying to force JMP to recognize information in a column as a date.  The number of steps the user must perform to bring JMP to recognize that information as a date is far too complex and time consuming.  

1. Enter data (in this case entered as m/d/y, but other entry formats exist)
2. Go to Column Info
3. Define the column as numeric (when it is a date, not normally thought to be a number)
4. Select modeling type as ordinal, so JMP sorts in date order
5. Click Format, then read a dozen or so possible formats, and choose date
6. For date format, determine which of 14 possible date formats I want to use

What is the improvement you would like to see? 

I request JMP should recognize obvious date entries and format them on behalf of the user.  Take that initial guess, and just do it.  If the user has personal preferences, country of origin typical formats, etc., let the distinct user preference be that user's burden.  Don't force everyone to wander through the formatting requirements.

 

Why is this idea important? 

Imagine the time savings you could give the users!  I know, making JMP more like Excel must be a common request, but in this date format example, I think it would be awesome.