Date formats used by Access SQL

Regardless of the regional settings of your PC, you must provide dates in US format for SQL statements in VBA. Use the following simple function to convert a UK date into a US-format date:

Function SQLDate (ByVal MyDate As Variant) As String
SQLDate = "#" & Format(MyDate,"mm/dd/yyyy") & "#"
End Function

Further information in the Microsoft Knowledge Base: Q149095 ACC

Calculate - an alternative to SQL

The Calculate() function - an alternative to SQL

FoxPro Gotcha

Common mistakes in Visual FoxPro

Creating a FoxPro array with SQL

Use _TALLY to avoid problems when you create an array of data with SQL in FoxPro.

Migrating to Access 2002

Migrating to Access 2002 from earlier versions of the database

SQL Subqueries in Microsoft Access

Using SQL queries and subqueries in Microsoft Access

Date formats used by Access SQL

Calculate - an alternative to SQL

FoxPro Gotcha

Creating a FoxPro array with SQL

Migrating to Access 2002

SQL Subqueries in Microsoft Access

April 2008

Microsoft Visual Foxpro and Access databases

Call: 0121 445 1300