problem in datediff...

This is the error:

--------

Error Type:

Microsoft OLE DB Provider for SQL Server (0x80040E14)

Invalid parameter 1 specified for datediff.

--------



And this is the code:

------

sql_del = "DELETE FROM table WHERE status=0 and DateDiff('d',date_record,GetDate()) > 15;"





db.execute(sql_del)

------



"date_record" helds the date where a record has been entered in the database (the database is SQL server) and it looks like this format "11/6/2002" or "6/6/2005".



Any ideas?



Thanks.

try



d without the single quotes!!



sorry if it doesnt work!

I fell for this one too...



In SQL Server its



sql_del = "DELETE FROM table WHERE status=0 and DateDiff(d,date_record,GetDate()) > 15;"



notice the lack of quotes around the first datediff parameter

thanks both micky & elija............it works.........

glad it worked
no problem!!