[thelist] Setting Default Date Values in SQL Server through ASP

Rob Smith rob.smith at thermon.com
Thu Apr 25 16:35:11 CDT 2002


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]

Hi

I have a field in an SQL Server 2000 (7) Database, which is in a date/time
format. I'm trying to set the date or the cell back to NULL. I've tried:

thing.fields.item("Date").value = ""
thing.fields.item("Date").value = NULL

what else could I try?

I keep getting that pesky 1/1/1900 date.

Rob



More information about the thelist mailing list