DataAssist Search behavior and Timestamp column
I have the standard DataAssist results page with a search form on it. A new column has recently been added to the database which is in Timestamp format i.e. yyyy-mm-dd hh:mm:ss although the time is not required. I rebuilt the Search facility but I've found that if I search on this field for a certain date, it doesn't work. I tried running a query directly on the database and discovered that using the following query gives zero results:
SELECT * FROM clients WHERE DateAdded LIKE '2015-03-05'
However if I add a % to the date it returns the correct results:
SELECT * FROM clients WHERE DateAdded LIKE '2015-03-05%'
My question is, where do I add that % on my results page so that the search function will work properly, or is there another way I can force the search to ignore the time part of the field?