Query Access with date time not working

[Grovkillen]

If I do this query using a ODBC Query Tool it works but using DBQuery command it renders a error.

Code: Select all

SELECT * FROM table WHERE modified > #2020-04-08 12:00:00#

But removing the time it work...

Code: Select all

SELECT * FROM table WHERE modified > #2020-04-08#

It's an older MDB file I'm querying.

[Grovkillen]

Google was my friend: https://www.thoughtco.com/formatting-da ... ql-1057843

Code: Select all

SELECT * FROM table WHERE modified > #2020-04-08 12.00.00#