FLUID: SQL error displayed when I click the lookup icon for a date field.
I have a date field in a Fluid page whose prompt is controlled via a dynamic view. The view sql is populated at runtime. Now, when I enter an invalid date (a value that is not there in the prompt), I get the usual invalid value error. After this I click on the lookup icon to open the search modal. When the search modal comes up, I get a SQL error.
E.g. enter 02/01/2018 in the date field. Note that this is not a valid value according to the prompt. So I get the standard Invalid value message. I click OK and then click on the lookup icon. Now the lookup modal comes up and a