Date range in searchCols

AndyTr

Hi,

I'm a relative newbie to both development and DataTables, but not shy of diving in at the deep end. Unfortunately I've lost about 3 hours of my day trying to solve this (what I hope is a) simple issue...

Can anybody please tell me how I filter on a date range using searchCols, please?

$('#example').dataTable( {
  "searchCols": [
    null,
    { "search": "2016-06-01~2017-02-01" },  // this is the range filter I want to use
    null,
    null
  ]
} );

Cheers

Andy

AndyTr

Help! Anybody?

I've just read on another forum post from 2014 that custom filtering client side doesn't work if using SSP, so I assume this is why everything I've tried has failed so far.

Is there a simple way of amending the stock SSP script to allow date range filtering, as per my code snippet above?

Any help is much appreciated!

Cheers

Andy