I am trying write an "SQL insert into" statement and I'm having problems inserting a date value into an Access 2k database.

This is the Insert Into statement that I'm using.

strInsert = "Insert into Notes (Notes, description, Keyword1, Date) Values ('Test Notes','test','keyword1','9/16/03')"

And this is the error I'm receiving.

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.
/project/updates.asp, line 38


Can anyone help me work out the format problem with the date value?

Thank you,

CO

Hi CO,

You have 2 error in your query.
1- Rename your field Date for something else, like EnterDate. Date is a reserved word for Jet.
2- You date value must be place between #. Your query should look like this:

strInsert = "Insert into Notes (Notes, description, Keyword1, EnterDate) Values ('Test Notes','test','keyword1',#9/16/03#)"


Stéphane Lajoie

It works. Thank for the help.

CO