I'm connected live to an ODBC data source and I seem to be getting a consistent error around 2 things. I have encountered this error in multiple tables in the data source.
1.) Relative date filters, every time I try to use a relative date filter I get an ODBC escape convert error. This happens regardless of which level of relative date filter I try to use (day/week/month).
2.) In an attempt to overcome this issue I attempted to use an IIF statement to to return true/false if the date part week numbers were the same.