Sort table date-eu in mysql datatables
Sort table date-eu in mysql datatables
EHT
Posts: 3Questions: 2Answers: 0
I generate my table with this code but my "type: 'date-eu', targets: 6" dosen't work:
$(document).ready(function() {
var dt = $('#example').DataTable( {
columnDefs: [
{ type: 'date-eu', targets: 6 }
],
"processing": true,
"serverSide": true,
"ajax": "tableau/ids-ndf.php",
"iDisplayLength": 25,
"columns": [
{
"class": "details-control",
"orderable": false,
"data": null,
"defaultContent": ""
},
{ "data": "ID_Ndf" },
{ "data": "Intitules_Ndf" },
{ "data": "Nom_Projets" },
{ "data": "Nom_Salaries" },
{ "data": "Prenom_Salaries" },
{ "data": "Dates_Ndf" },
{ "data": "Total_TTC_Ndf" },
}
],
"order": [[1, 'desc']]
} );
When i sort i have:
01/01/2013
01/03/2013
01/04/2014
01/06/2013
01/06/2013
And i want:
01/01/2013
01/03/2013
01/06/2013
01/06/2013
01/04/2014
Can you help me please?
Where is my fail
This discussion has been closed.
Answers
help please