Query is invalid syntax in pyodbc python but working on mssql server

Question

this is the query:

select count(ID) as total_new_records from dbo.WarrantyCard where DATECREATED >= dateadd(day, datediff(day, 0, GetDate()) - 7, 0)

Answer 1

Maybe check if you are using the correct driver in your ODBC connection.
This issue suggests other people have similar trouble with date handling in mssql via pyodbc...
https://github.com/mkleehammer/pyodbc/issues/658