Date column not sorting as it is a character

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

Please screenshot,

as @txnelson pointed out, you have to convert it to a proper continuous time value to work with it.

The display format is not important, it is only how the internally stored datetime is displayed.

But it is essential how the given string is interpreted, in your case you need to specify the appropriate informat, see screenshot and table script.

In that case I copied the column, because after conversion the original string is lost. In my case I had also to switch to JMP locales under preferences, Window specific, to see the proper datetime format (I have german windows system).

New Table( "time_sort",
	Add Rows( 5 ),
	New Column( "Proc Time",
		Character,
		"Nominal",
		Set Values(
			{"1/12/2021 11:44:32 AM", "1/12/2021 11:44:32 AM",
			"1/12/2021 11:44:32 AM", "1/12/2021 11:44:32 AM",
			"1/12/2021 11:44:32 AM"}
		),
		Set Display Width( 177 )
	),
	New Column( "copy_date",
		Numeric,
		"Continuous",
		Format( "Locale Date Time h:m:s", 23, 0 ),
		Input Format( "m/d/y h:m:s", 0 ),
		Set Selected,
		Set Values( [3693296672, 3693296672, 3693296672, 3693296672, 3693296672] ),
		Set Display Width( 183 )
	)
)