Hello,
I created simple MSSQL 13.0 DB application with advDBFilterPanel,AdvDBgrid and FireDAC components, works great except when filtering Datetime field I get conversion error.
I cought generated query with FDmonitor and it would work if only condition datetime value would have single quotes.
generated query : SELECT * FROM tabela1 WHERE polje6 < 1.01.2150 - firedac raise exception
modified by hand: SELECT * FROM tabela1 WHERE polje6 < '1.01.2150' returns records
Is there any workaround
In order to accommodate different SQL variations to specify dates in the WHERE clause, we've added a property SQLDateSeparator, so, in the next update, you'll be able to set this to ' to handle this case.