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".
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.