Use International Date Formats in SQL Statements
From Microsoft Access Visual Basic
Use International Date Formats in SQL Statements
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.