Eine Einführung in

SQL

Insert a date.

MS Access

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.

Execute tidy up code silently


Specific to MS Access

When used within VBA Access likes dates to be enclosed in hash signs...

#20 May 1962#