[thelist] 1/1/1900 SQL Server/ASP Question

[josh]

I am updating a database field via a web form.  When a date is placed in the 
field the database updates correctly.  When the form is left blank, the 
database assumes the value 1/1/1900. 

Here is the database update call: 

<code snippet> 

rs.Open "UPDATE t_table SET t_cr_ccss_review_date = '" & 
request.form("the_date") & "' WHERE id=" & request.form("id") 

</code snippet> 

Does anyone know what I have done wrong? 

Thanks,
Josh