>SqlServer does not supp[ort DATE type fields. It support DateTime type fields only. You must convert Your Date to DateTime with DTOT() or pass it as a string (I never tested this, but books convince me it's work) with format "yyyymmddhhmmss".
SQL server doesn't have a date datatype but conversion is automatic when only date is passed.
PS: Yes 'yyyymmddhhmmss' string format is canonical ODBC format that also works.
Cetin