topic Sorting a nominal date and time in Discussions

Sorting a nominal date and time

twillkickers — Wed, 17 Oct 2018 19:10:16 GMT

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?

Re: Sorting a nominal date and time

txnelson — Wed, 17 Oct 2018 19:21:46 GMT

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

Re: Sorting a nominal date and time

mostarr — Thu, 06 May 2021 01:10:01 GMT

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

Mike