I have a field 'OrderDate' and I simply want to enable extended search on it. Whenever I enable extended search or filter, it displays the following error:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.
I'm stuck here. Can someone help on this?
Thank you.