Date problem

Here is my problem. I have the following code (JSCRIPT).

var date_aujourdhui = new Date();
...
Insertion_Commentaire = oConn.execute("INSERT INTO T_Commentaires (Date_Commentaire, CE_Membre, Commentaire, CE_No_Photo) VALUES (" + date_aujourdhui + "," + num_diplome + ",'" + nouveau_commentaire + "'," + num_photo + ")");
Response.write("Votre commentaire a bel et bien été ajouté." + date_aujourdhui);

The Date_Commentaire field is a date field but I get the following error :

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Fri Jul 25 09:46:52 2003'.

/dev/insertion_commentaire_2.asp, line 24

Can you help me?

Dates in Access need to be surrounded by ##, so try something like:

.. VALUES (#" + date_today + "#," + ....

(he he - love my French  )

Cheers,
Andrew