1 of 1 people found this helpful
The error typically is occurring because the Generic ODBC connector for MySQL does not support the SQL syntax used when querying for date fields.
The options documented in the article below should resolve the issue.
I hope this helps
Hi Sebastian, thanks for your reply.
At the end I used a calculated field to add hours within daylight ranges.