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.