When inserting a date into an Access database you should use the format YYYY-MM-DD. Our function AccessDate returns a date in YYYY-MM-DD format.
When working with a date in Access always use the # delimiters in your SQL statement.
Platform(s): Windows
Date: Dec, 13 2005
Author: Michael Wall, http://www.codefixer.com/codesnippets/insert_date_access_sql.asp
3.0