mrjoshfisher on "[Plugin: TablePress] Not Sorting By Date"

Hello,

Im having an issue with a table on my site, I have several dates in a column all formatted as dd/mm/yyyy and im using the code

"aoColumnDefs": [ { "sType": "date", "aTargets": [ 3 ] } ]

to sort it but for some reason when I click sort it sorts it in order except for one date, it'll go

20/09/2016
20/08/2016
19/09/2016

and as we all know the 8th comes before the 9th, any reason for this ?

https://wordpress.org/plugins/tablepress/

Hi,

thanks for your question, and sorry for the trouble.

The reason for this is that this a dd/mm/yyyy date format. To sort those, please take a look at the TablePress Extension from https://tablepress.org/extensions/datatables-sorting-plugins/
With that, you should not need that "Custom Command" either.

Regards,
Tobias

all the dates in the column are in the format dd/mm/yyyy and those without dates are just blank, but its still that one row with the date 20/08/2016 that comes in between the two dates, is it because there is a 0 before the month ?