Hi,

So I have a FormView, and one of the fields is a DateTime field. Some of the values for this column in the database are NULL. It's fine when it is bound declaratively, but as soon as I try to do it manually, I can't seem to update the database correctly. If I try to write a VBNULL or empty string back to the database, it converts it to something like 1/2/1900 12:00 AM.

What can I do???

Thanks.

Aaron

Pretty tough to advise you without seeing any code.

Passing an empty string to the database will cause the value to be converted to midnight on 1/1/1900. I would try assigning System.DBNull.value to it. SQL should see this as an actual NULL and handle it accordingly.