Updated: 12/13/2005

Insert Date into Access Database

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.

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Tags
  • access database sql,
  • access date format sql,
  • access format date sql,
  • access sql,
  • access sql date function,
  • access sql function,
  • date format function sql,
  • date format in sql,
  • date format sql,
  • date format sql access,
  • date function in sql,
  • date function sql,
  • date in sql,
  • date sql,
  • date sql format,
  • date sql function,
  • delimiters in sql,
  • format date sql,
  • function in sql,
  • function sql,
  • in function in sql,
  • in function sql,
  • inserting date in sql,
  • inserting in sql,
  • inserting into sql,
  • sql database access,
  • sql date,
  • sql date format,
  • sql date format access,
  • sql date format function,
  • sql date function access,
  • sql format date,
  • sql format date function,
  • sql function date,
  • sql function date format,
  • sql inserting,
  • sql inserting date
  • ...
• Platforms
  • Windows
• Licenses
  • Freeware
• Author
  • Michael Wall