UK format column filtering

UK format column filtering

aCoradatatblaCoradatatbl Posts: 16Questions: 7Answers: 0
edited October 2015 in Free community support

hi
I need to filter uk format dates in a column in my datatable (latest version) Im using serverside php to convert the column from mysql format yyyy/mm/dd to more friendly version in that column - "jS M Y" - producing nice looking dates thus: 1st Sep 2015.

How do i filter on this column so user can find matching rows when typing in exactly what they want. Right now it only matches the first 2 numbers. As soon as they type in the Suffix part (th, nd, rd) the dreaded "No Matches" appears when there obviously are dozens of matches present. My Server-side is doing the conversion successfully defined in the $columns array => 'formatter' in php so i'd like this function to also affect the filter. Any ideas please?

much thanks in advance ...

This discussion has been closed.