SearchBuilder Requires DateTime when used with dates.

tim1955 · April 21

I am a newbie but steadily learning. I set up Datatables with jQuery and it is working fine.
When I tried to use DataTables on a PHP generated table I received the error "SearchBuilder Requires DateTime when used with dates.". So I changed the field in the MySQL table from type DATE to type DATETIME. But I am still getting the same error. Do I need to add a jQuery line to my initialization file shown below? If so, could someone provide an example?
Thanks for any assistance. And thanks for a superb product! It is proving very useful for our non-profit organization.
Tim

$( document ).ready(function() { $('#mytable').DataTable( { colReorder: { columns: ':not(:first-child)' }, scrollx: true, responsive: { breakpoints: [ {name: 'bigdesktop', width: Infinity}, {name: 'meddesktop', width: 1480}, {name: 'smalldesktop', width: 1280}, {name: 'medium', width: 1188}, {name: 'tabletl', width: 1024}, {name: 'btwtabllandp', width: 848}, {name: 'tabletp', width: 768}, {name: 'mobilel', width: 480}, {name: 'mobilep', width: 320} ] }, layout: { top1: 'searchBuilder', bottom2Start: 'buttons' }, buttons: ['copy', 'pdf', 'excel'] } ); });

tim1955 · April 21

PS The date format I would like is 2024-03-22.
Time is not needed.
Thanks again,
Tim

allan · April 21

Hi Tim,

Sorry it isn't clear, the error message means that it needs the DateTime library. You can include it from the download builder.

Allan

tim1955 · April 21

Many THANKS for your quick and helpful reply!
Everything is working fine now.
Best Regards,
Tim in Montana USA

SearchBuilder Requires DateTime when used with dates.

SearchBuilder Requires DateTime when used with dates.

Answers

Howdy, Stranger!

Categories

DataTables

SearchBuilder Requires DateTime when used with dates.

SearchBuilder Requires DateTime when used with dates.

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables