Sort Date format d/m/Y about datatable HOT 6 CLOSED

How do you create the datable? Do you use an existing table or JSON array (or something else)?

If the data inside the datatable are of Date type (not string), then setting using the sort option should be sufficient.

from datatable.

I used an existing table, created dynamically with php.
I have tried with format 'Y/m/d', works and it orders. But I need show in format 'd/m/Y'.
Thanks.

from datatable.

You can try to use the dataTypes options:

$('#my-table').datatable({
    dataTypes: [true, true, 'date', true, ..., true]
});

You need to fill dataTypes with true for all other columns. Using 'date', the plugin will try to convert your string to:

new Date(/* initial string */);

If the default converter does not work, you can use a custom one:

function customDate(s) {
    // Here you can do whatever you want to convert your string to a date
    var dmy = s.split('/');
    return new Date(dmy[2], dmy[1], dmy[0]);
}

$('#my-table').datatable({
    dataTypes: [true, true, customDate, true, ..., true]
});

from datatable.

Works perfectly, but now it shows me the date in long format

And if I try to change it with the .toLocaleDateString ("es-ES") function

function customDate(s) {
     // Here you can do whatever you want to convert your string to a date
     var dmy = s.split('/');
     var options = { year: "numeric", month: "2-digit", day: "2-digit", hour12:"false"};
     return new Date(dmy[2], dmy[1], dmy[0]).toLocaleString('es-ES', options);
}

Not reorder it:

With the dataTypes: [true, true, 'date'...... Exactly the same happens, show the format long.

from datatable.

You want to internally store date as Date and then process the output, so you need to use the lineFormat option:

function customDate(s) {
    // Here you can do whatever you want to convert your string to a date
    var dmy = s.split('/');
    return new Date(dmy[2], dmy[1], dmy[0]);
}

$('#my-table').datatable({
    dataTypes: [true, true, customDate, true, ..., true],
    lineFormat: function(id, data) {
        var res = $('tr');
        for (var key in data) {
            if (data.hasOwnProperty(key)) {
                var value = data[key];
                if (value instanceof Date) {
                    value = toLocaleString('es-ES');
                }
                res.append('<td>' + value + '</td>');
            }
        }
    }
});

from datatable.

ok, thanks!!!! Now works perfectly.

Thanks so much!!, regards.

from datatable.