Date sorting is not working with year, then month in descending order

Asked Aug 03 '23 at 10:51

Active Aug 03 '23 at 19:26

Viewed 42 times

-3

New to coding, help is appreciated. I have a jQuery data table which displays the buttons for Excel, PDF, Copy on top of the table and the drop down for page entries to show 10,25,50,100.

I have my date in US format (month-date-year), but the date isn't sorting properly from current date to oldest date:

Please can you help me out to start the sorting as follows:

I have tried this and the sorting isn't working for me:

<script type="text/javascript">
$(document).ready(function() {
   
    var table = $('#tableID').DataTable({
        
        columnDefs: [
            {
                targets: [0], 
                type: 'date-us', 
            }
        ],
        order: [[0, 'asc']], 
        dom: 'Bfrtip', 
        buttons: [
            'excel', 'pdf', 'copy' 
        ]
    });
});

</script>

edited Aug 03 '23 at 12:17

asked Aug 03 '23 at 10:51

P-Stylz

Please [do some research](https://www.google.com/search?q=fdatatables+sort+us+dates) – mplungjan Aug 03 '23 at 10:59
I've searched and the solutions I have found are not working for my project, plus I'm new to Jquery. Any help is appreciated. – P-Stylz Aug 03 '23 at 11:12
1

Just switch the order here: https://stackoverflow.com/questions/68159588/datatables-how-to-sort-by-date-dd-mm-yyyy – mplungjan Aug 03 '23 at 14:49
Much appreciated. I tried it and I couldn't get it to work. Thank you for your help. – P-Stylz Aug 03 '23 at 17:47
Please post [mcve] – mplungjan Aug 03 '23 at 19:18
1

Works for me: https://jsfiddle.net/mplungjan/v0u698md/ – mplungjan Aug 03 '23 at 19:26

Date sorting is not working with year, then month in descending order

0 Answers0