Order by spanish date with datatables
Personalized plugin for order datatables with spanish date dd/mm/yyyy hh:mm
Copy this code and paste it in your HTML
jQuery.fn.dataTableExt.oSort['fechaes-asc'] = function(a,b) {
var aux_a
= a
.split(" "); var aux_b
= b
.split(" "); var fecha_a
= (aux_a
[0]).split("/"); var hora_a
= (aux_a
[1]).split(":"); var fecha_b
= (aux_b
[0]).split("/"); var hora_b
= (aux_b
[1]).split(":");
var date_a
= new Date(fecha_a
[2], fecha_a
[1], fecha_a
[0], hora_a
[0], hora_a
[1]); var date_b
= new Date(fecha_b
[2], fecha_b
[1], fecha_b
[0], hora_b
[0], hora_b
[1]);
return ((date_a < date_b) ? -1 : ((date_a > date_b) ? 1 : 0));
};
jQuery.fn.dataTableExt.oSort['fechaes-desc'] = function(a,b) {
var aux_a
= a
.split(" "); var aux_b
= b
.split(" "); var fecha_a
= (aux_a
[0]).split("/"); var hora_a
= (aux_a
[1]).split(":"); var fecha_b
= (aux_b
[0]).split("/"); var hora_b
= (aux_b
[1]).split(":");
var date_a
= new Date(fecha_a
[2], fecha_a
[1], fecha_a
[0], hora_a
[0], hora_a
[1]); var date_b
= new Date(fecha_b
[2], fecha_b
[1], fecha_b
[0], hora_b
[0], hora_b
[1]);
return ((date_a < date_b) ? -1 : ((date_a > date_b) ? 1 : 0));
};
Report this snippet
Comments
Subscribe to comments