358593_en-US

liliconcom

Date column not sorting as it is a character

I have a dataset and trying to sort by date.
I am having issues I have tried to informat the column as it been read in as a character.

But with no success. Have attached the dataset without the informat

Data TableRe: Date column not sorting as it is a character

I would suggest checking out Data Table Tools Add-in by @brady_brady 

 

 

 

 

Re: Date column not sorting as it is a character

To turn this into  proper JMP Date/Time numeric value:

1. Right click on the column header and select "Column Info"
2. Change the Data Type from Character to Numeric
3. Change the Modeling Type from Nominal to Continuous
4. Select from the Format..........Time=>m/d/y h:m:s
5. Click OK