Hi, I am using sql server 2000 and coldfusion. I have a form where I am asking the user to supply dates. (e.g 4/27/2007).
In my database I have the date type smalldatetime. When the field is left blank, the date stored in the database is 1/1/1900.
I want it so if the field is blank and the user did not supply a date, then there should be no value in the database.