Hi, I have a problem with filtering by date range. When I try to use table.draw() the search doesn’t work at all, but when I define a column like table.columns(8).search( this.value ).draw(); then it searches but doesn’t do a range.
I tried something like this
`var minDate, maxDate;
// Custom filtering function which will search data in column four between two values
$.fn.dataTable.ext.search.push(
function( settings, data, dataIndex ) {
var min = minDate.val();
var max = maxDate.val();
var date = new Date( data[4] );
if (
( min === null && max === null ) ||
( min === null && date <= max ) ||
( min <= date && max === null ) ||
( min <= date && date <= max )
) {
return true;
}
return false;
}
);
$(document).ready(function() {
// Create date inputs
minDate = new DateTime($('#min'), {
format: 'YYYY-MM-DD'
});
maxDate = new DateTime($('#max'), {
format: 'YYYY-MM-DD'
});
// DataTables initialisation
var table = $('#example').DataTable();
// Refilter the table
$('#min, #max').on('change', function () {
table.draw();
});
});
`
but when i change the value nothing happens.