Problem with sorting column by datetime

voloderlejla

I added in head of html :


and in datatable
order: [[2, "desc"]],
columnDefs: [{ type: 'date-eu', 'targets': [2], orderable: true }], and before initialising datatable
$.fn.dataTable.moment('DD.MM.YYYY HH:mm:ss');
But it doesn't work. What can I do to fix this problem?

voloderlejla

in head I added two scripts :
https://momentjs.com/downloads/moment-with-locales.min.js
https://cdn.datatables.net/plug-ins/1.10.15/dataRender/datetime.js

kthorngren

$.fn.dataTable.moment('DD.MM.YYYY HH:mm:ss');

To use this for sorting you need the two scripts noted in the datetime sorting blog.

Also, it looks like your moment format is wrong. Your date format is 26.1.2021 and your format is DD.MM.YYYY. Since your dates don't include a leading 0 for the month and day you will need to use D.M.YYYY instead. Please refer to the moment format docs for a list of all the formats.

Kevin