2650Insert Date into Access Databasehttp://www.codefixer.com/codesnippets/insert_date_access_sql.aspWhen inserting a date into an Access database you should use the format YYYY-MM-DD. The 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.
The database is called 'dbDate', the table 'tblDate' and date field 'dDate'. The 'dDate' field is a DATE/TIME datatype.ASP > Tips and Tutorials > Date and TimeOct 10, 2006Michael Wall
Learn how to post on a web page using ASP programing the date & time. This tutorial is for beginers and explains in a very simple method how to display the date & time.
This function is very useful, if you wish to get date of current SQL server date and time. You may use this function to fill some rows automatically with current time or using with DateDiff function to return the number between current time.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.