Sorting a nominal date and time

[#1]

I have created a column for a nominal value for a date and time, however, it does not remain sorted by date and time. How do I sort this column appropriately?

Capture.PNG

[#2 · Accepted solution]

The issue is not that the data are nominal, but that the data is character. The easiest way to deal with this is to convert the datatype into a numeric date/time column, and then set the modeling type to nominal

[#3]

This doesn't work for me when the date is in MM/DD/YYYY format. In fact it gives a (non-critical) error.

Mike