I have a datatable with aoColumnDefs containing:
{ "sType": "date-range", "aTargets": [0] }
The dates in this column are strings in the form "MM/dd/yyyy - MM/dd/yyyy". Unfortunately, this column is currently sorting incorrectly. Instead of sorting by year, then month, then day, it is sorting by month then day then year.
I assume that this is a date format issue (because it is sorting the date parts from left to right, assuming that my date is yyyy/mm/dd).
Is there a way to set the date format used while sorting dates on datatables?
NOTE: I know I can sort on a hidden field. This was causing me other issues, and I want to know if I can solve the problem another way.