How to sort date with yyyy-mm-dd format. By using datatables [js]?

Question

I need to sort date with yyyy-mm-dd format.

$( function () {
    $.fn.dataTable.moment('YYYY-MM-DD');

    $('#tbTest').DataTable();
});

But I still got the wrong sort (See picture below)

enter image description here

How can I fix this?

Shiffty · Accepted Answer · 2015-03-13 08:13:13Z

6

If you check the unshift function in the datatable plugin you see that moment has the strict parameter defined true.

    // Add type detection
    types.detect.unshift( function ( d ) {
    return moment( d, format, locale, true ).isValid() ?
        'moment-'+format :
        null;
    } );

From the moment docs:

Moment's parser is very forgiving, and this can lead to undesired behavior. As of version 2.3.0, you may specify a boolean for the last argument to make Moment use strict parsing. Strict parsing requires that the format and input match exactly.

So instead of:

$.fn.dataTable.moment('YYYY-MM-DD');

which would require a date like 2015-04-01, you have to use:

$.fn.dataTable.moment('YYYY-M-D');

answered Mar 13, 2015 at 8:13

Shiffty

2,1662 gold badges27 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to sort date with yyyy-mm-dd format. By using datatables [js]?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related