I have a "Dev_Date" field in an Access database. The type is Date and the format is Long. I have an ASP page using Javascrip to construct a Long Date variable of the current date and using the built-in INSERT record behavior to insert it, along with other data, into the table. This is the actual SQL statement:

insert into Devotionals (Title,Devotional,Dev_Date) values ('Test 1','This is a test.',#Saturday, January 10, 2004#)

This is the error I get.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '#Saturday'.

/admin/devotionals/devotionals_add.asp, line 100

Can someone please help. I've search for a while on the web and can't find anything about it.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>

Can someone please help. I've search for a while on the web and can't find anything about it.

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Please have a look at

www.4guysfromrolla.com/ASPScripts/PrintPage.asp?REF=%2Fwebtech%2Ftips%2Ft022202-1.shtml

Good luck,
fskilnik

Edited by - fskilnik on 22 Nov 2005 17:54:26