Filter a recordSet by year using the date column

I have a recordSet that selects two columns ( snippet , date [ yyyy-mm-dd ] ) from a NEWS database table. I am using the recordSet to create a list using a repeat region. I would like to be able to filter the list by year from a dropdown that sits above the list. I have been trying to use the 'DataAssist Search Behaviour' to achieve the task but can not work out how. I have managed to get a filter working but only as a comparison 'Less or equal to' that uses a parameter in a url. But I would need to filter between to dates to cover a year.

Any pointers please.

Ive attached page so you can see what I have tried so far.

thanks in advance

There are probably a couple of ways you could do it, but one option would be to use something like:

$WADbSearch1->addComparison("date","".isset($_GET['year']?"1/1/".$_GET['year']:"")  ."","AND",">=",2);

  $WADbSearch1->addComparison("date","".isset($_GET['year']?"12/31/".$_GET['year']:"")  ."","AND","<=",2);

and then just pass the ?year=2017 or whatever year in the url. You would want to also update the if statement of the filter to:

if (isset($_GET['year'])) {

Thanks Ray.. this is just the job!!

I would also like to have another option to flip the list between oldest or latest by date.

I realise I can achieve this if i used a table with the 'sort behaviour'

But the list I'm filtering is in an 'unordered list'. So is there another way I can do this?

Thanks in advance.

It might be possible to find a jquery option to do the sort of the unordered list in javascript, but I've always done it with the recordset and sorting that way.