Use International Date Formats in SQL Statements

Access Developer Reference

You must use English (United States) date formats in SQL statements in Visual Basic. However, you can use international date formats in the query design grid.