Eine Einführung in
The format of dates can be very tricky. Most implementations are fairly robust in what will be accepted - but a date such as 01-02-03 might be interpreted in different ways in different countries.
Using a three character month and a four digit year in single quotes (such as '01 Mar 1997') works safely with most systems other than MySQL.
|Specific to MS Access|
When used within VBA Access likes dates to be enclosed in hash signs...
#20 May 1962#