You send dates to Sql Server as string literals. Sql Server can recognize a few different types of date string. See 'datetime data type, formats' in BOL for details. Also remember that Sql Server has only datetime data type that includes time portion. You should always take that in account.

>Hi...
>
>I would like to know how can I build my SQL statement to use a date variable in the WHERE clause... This SQL statement will be send using : recordset=connectionObject.execute(my_SQL_statement)
>
>the connectionObject is an ADODB.connection object connected on a SQL Server.
>
>Thanks...