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
mostarr
mostarr
Level IV

Sorting a column by date (i.e. chronologically) when it is is MM/DD/YYYY format, not using JSL but using the GUI

Created: May 5, 2021 09:15 PM  |  Last Modified: Jun 10, 2023 4:29 PM (1679 views)

I haven't seen a solution for this scanning through the first few pages of Google so far. There are scripting-based solutions, and some related GUI solutions that do not work for whatever reason.

 

Can we get this basic functionality up and running?

 

Mike

0 Kudos
1 REPLY 1
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager

Re: Soring a column by date (i.e. chronologically) when it is is MM/DD/YYYY format, not using JSL but using the GUI

May 5, 2021 09:41 PM (1667 views)  |  Posted in reply to message from mostarr 05-05-2021

If your date column isn't sorting numerically it's because it's not stored as a date value. It's stored as a character string. You can confirm this by looking at the justification in the data table. 

2021-05-05_21-35-29.574.png

Left justified columns are character strings. Right justified columns are numeric.

 

You can change the data type for your column by double-clicking at the top of the column to get the Column Info dialog box.

 

Change the data type to Numeric and the format to any of the Date formats.

 

Set the Input Format to m/d/y and JMP will convert your strings into date values.

 

2021-05-05_21-34-20.095.png

Be sure to read Using dates, times, datetimes and durations in JMP  to understand how JMP stores and deals with those values.

-Jeff