[thelist] Setting Default Date Values in SQL Server through A SP
Rob Smith
rob.smith at thermon.com
Thu Apr 25 16:52:00 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 ]
>> I have a field in an SQL Server 2000 (7) Database, which is in a datetime
>> format. I'm trying to set the date or the cell back to NULL. I've tried:
>WAGs:
>thing.fields.item("Date").value = "NULL"
>thing.fields.item("Date").value = Empty
Sorry that didn't work. The "NULL" attempt resulted in a type mismatch. The
Empty attempt still gave the me default date value of "1/1/1900"
What else could I try?
Rob
More information about the thelist
mailing list