Search

Hi @AAS , Yep, it's because by default it will be using standard dates (MM/DD/YYYY) - to convert to British (DD/MM/YYYY), do something like this. Cheers, Colin

Ok. Thank you Allan. I'll give those a try.

Thank you @colin and @allan ! Both work.

Hi @WebCodex , It looks like you're having a conversation with yourself there! :smile: From your last line, I'm guessing all is good now? Cheers, Colin

As for the sorting I figured it out as you said (thanks!), I'll post it here for reference : { "targets": 0, "render": function ( data, type, row, meta ) { console.log(data.split('%')[0]); return type === 'sort' ? data.split('/')[0] : data; } }

Ok got it ! I didn't understood the real scope of the wildcard "_" when defining columns. So I change my code for setting only this stuff to the data value, and setting a "display" property for the formatted string and it works. https://jsfiddle.net/LittleLama/ek9w68tL/35/

Maybe you can use columns.render to provide the date in a format that the sort operation can use (without the ()) as described here: https://datatables.net/manual/data/orthogonal-data Kevin

Yes, exactly what @jvretamero says! You would use a custom sorting function that just coverts everything to lowercase so it will all remain the same: .sort( function ( a, b ) { return a.toLowerCase() > b.toLowerCase(); } ) http://live.datatables.net/gejojiqu/100/edit Your other option is to use an Intl Collator in the sort which has options to do a case insensitive sort. Allan

to attach the DataTables ordering listener to any element.

Documented here: https://datatables.net/manual/server-side