[thelist] Setting Default Date Values in SQL Server through A SP

[Rob Smith]

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