Dates not sorting properly

[skykep]

Date sorting is not working as intended. Single-digit months are being weighed higher than double digit.
For example, a descending order will go as follows:
6/1/2020
5/1/2020
4/1/2020
3/1/2020
11/1/2020
10/1/2020

[skykep]

If I format the date/time a little bit with moment, it'll sort properly (sort of).
It sorts from left to run, so the year needs to be first, then month, then day...and so on. If using 12-hour mode with an am/pm appended at the end, it will actually put 8:26am later than 8:35pm.

[mfridman]

Similar deal with the MM-DD-YYYY format. I didn't bother playing around with the existing JS.

@skykep any chance you have a copy/paste solution 😛

[skykep]

Are you saying you prefer the dashes instead of slashes?
I got around my problem by formatting it using moment.
Try formatting your dates using moment().format('L'); If you need the dashes, that may not work.

[mfridman]

Ahh, I thought it supported both dashes or slashes since the website example used both:

But as you mentioned, can be solved by tweaking the underlying parser.

[skworden]

As a workaround - you can convert the date to seconds and then use that value in the data-sort attribute. See docs.

<td data-sort='1620178326325'>05/04/2021</td>