Hi everyone I am using datatables plugin and have issue with date column sorting. What i am doing is porting current working project with MDB Pro 4.7.3 to new rewrited project using MDB Admin Pro Template but date columns isnot sorting correctly. My date formad is Turkish date format like 22.03.2019.

With the new template date columns sorted as string not as date which means it is sorting first days then month and lastly year part.

Here is the datatable initialisation code:

jQuery.fn.dataTableExt.oSort['day-asc'] = function(a, b) {
    var daya = a.split('.');
    var dayb = b.split('.');

    var x = (daya[2] + daya[1] + daya[0]) * 1;
    var y = (dayb[2] + dayb[1] + dayb[0]) * 1;

    return ((x < y) ? -1 : ((x > y) ? 1 : 0));
};

jQuery.fn.dataTableExt.oSort['day-desc'] = function(a, b) {
    var daya = a.split('.');
    var dayb = b.split('.');

    var x = (daya[2] + daya[1] + daya[0]) * 1;
    var y = (dayb[2] + dayb[1] + dayb[0]) * 1;

    return ((x < y) ? 1 : ((x > y) ? -1 : 0));
};

 var table = $('#tblasansor').DataTable( {
        "dom": "<'row'<'col-12'B>><'row'<'col-md-5 col-12'l><'col-md-7 col-12'f>r><'table-responsive't><'row'<'col-md-5 col-12'i><'col-md-7 col-12'p>>",
        // dom: "BfrtiSp",
        "processing": true,
        "serverSide": true,
        // searching: true,
        // info: true,
        paging: false,
        "scrollY": "50vh",
        deferRender: true,
        // scrollY: 500,
        scrollX: true,
        scrollCollapse: true,
        responsive: true,
        autoWidth: false,
        "aaSorting": [[5, "desc"]],
        "pageLength": 10,
        'lengthMenu': [[10, 20, 25, 50, -1], [10, 20, 25, 50, 'All']],
        // "lengthMenu": [10, 15, 25, 50, 100, 250, 500, 1000],
        "pagingType": "full_numbers",
        "language": {
            "sProcessing": "İşleniyor...",
            "sLengthMenu": "Sayfada _MENU_ Kayıt Göster",
            "sZeroRecords": "Eşleşen Kayıt Bulunmadı",
            "sInfo": "  _TOTAL_ Kayıttan _START_ - _END_ Arası Kayıtlar",
            "sInfoEmpty": "Kayıt Yok",
            "sInfoFiltered": "( _MAX_ Kayıt İçerisinden Bulunan)",
            "sInfoPostFix": "",
            "sSearch": "Bul:",
            "sUrl": "",
            "oPaginate": {
                "sFirst": "İlk",
                "sPrevious": "Önceki",
                "sNext": "Sonraki",
                "sLast": "Son"
            },
            buttons: {
                excel: 'Excel`e Aktar',
                colvis: 'Düğme Gizle/Göster'
            }
        },
        buttons: [
            'excel',
            'colvis'
        ],
        columnDefs: [
            {
                "visible": true
            },
            {
                "targets": 7,
                "createdCell": function (td, cellData, rowData, row, col) {
                    if ( cellData == 'kirmizi' ) {
                        $(td).css('background-color', 'red');
                        $(td).css('color', 'white');
                        $(td).css('font-weight', 'bold');
                    }else if ( cellData == 'yesil' ) {
                        $(td).css('background-color', 'green');
                        $(td).css('color', 'white');
                        $(td).css('font-weight', 'bold');
                    }else if ( cellData == 'sari' ) {
                        $(td).css('background-color', 'yellow');
                        $(td).css('color', 'white');
                        $(td).css('font-weight', 'bold');
                    }else if ( cellData == 'mavi' ) {
                        $(td).css('background-color', 'blue');
                        $(td).css('color', 'white');
                        $(td).css('font-weight', 'bold');
                    }else {
                        $(td).css('background-color', 'grey')
                    }
                }
            },
            { type: 'turkish', targets: '_all' }
        ],
        "aoColumns": [
            /* # */ {"bSearchable": false, "bSortable": true},
            /* binaadı */ {"bSearchable": true, "bSortable": true},
            /* kimlikno */ {"bSearchable": true, "bSortable": true},
            /* ilçe */ {"bSearchable": true, "bSortable": true},
            /* eleman */ {"bSearchable": true, "bSortable": true},
            /* Kontrol Tarihi */ {"bSearchable": true, "bSortable": true, "sType": "day"},
            /* Kontrol Tipi */ {"bSearchable": true, "bSortable": true},
            /* sonuç */ {"bSearchable": true, "bSortable": true}
        ],
        scroller: {
            loadingIndicator: true
        },
        "ajax": "*************************************"
    } );
    // Setup - add a text input to each footer cell
    $('#tblasansor tfoot th').each(function () {
        var title = $(this).text();
        $(this).html('<input type="text" placeholder="' + title + '" />');
    });

    table.columns().every(function () {
        var that = this;

        $('input', this.footer()).on('keyup change', function () {
            if (that.search() !== this.value) {
                that
                    .search(this.value)
                    .draw();
            }
        });
    });
    $('#tblasansor tfoot tr').appendTo('#tblasansor thead');