Search

See this blog if you are using a Datatables version less than 1.12. If using 1.12 then see this note about datetime sorting with 1.12.

$(document).ready(function () { var table = $('#example').DataTable( { language: { searchPlaceholder: "Search records",

Hi,

$('#button').click(function () { //alert(table.rows('.selected').data().length + ' row(s) selected'); var d = (table.rows('.selected').data()); var leng

}); $('#button').click(function () { //alert(table.rows('.selected').data().length + ' row(s) selected'); var d = (table.rows('.select

}); //$('#button').click(function () { // alert(table.rows('.selected').data().length + ' row(s) selected'); //}); $('#example

return formatedDate; } if ($("#BusinessDateTIme").val() != "" && $("#BusinessDateTIme").val() != null) { var formatedBusinessDate =

} }, table: '#businesses', fields: [ { "label": "Company:", "name"

/* Formatting function for row details - modify as you need */ function format(d) { // `d` is the original data object for the row return ( '<table cellpadding="5" border=

Are you using Datatables 1.12? If yes then see this doc. Otherwise see the sorting dates blog.

I have an issue when a user clicks the Excel button it only exports the records on the current page.

See this FAQ.

$('#example tbody').on('click', 'tr', function () { $(this).toggleClass('selected'); }); $('#button').click(function () { alert(table.rows('.selected').data().

Hi,

If you have Datatables 1.12 then see this doc. If using a previous version see this blog.

Did you add a statement like this to tell Datatables the datetime format?

$( '#builders-datatable' ).DataTable( { scrollX: true, pageLength: 50, pagingType: 'full_numbers', order: [ [ 1, 'asc' ] ], dom: 'lBfrtip', buttons: buttonSettings } );

$( '#builders-datatable' ).DataTable( { scrollX: true, pageLength: 50, pagingType: 'full_numbers' } );

Did you read the FAQ I linked to. I think it will answer your question.

Maybe this FAQ explains the issue?