Is there a reason you would not just use a null value?

>Wayne,
>
>>>What happens if you really do need to store 1/1/1900 in the table?<
>
>Good question ... probably use the time component of the datetime field to further determine whether it's a valid date or not. The time (something other than midnite) would be something you'd have to consciously put into the column.
>
>~~Bonnie
>
>
>>
>>>
>>>We handle it this way: we leave the data as is in the table, but handle how it's displayed in a custom date control. You *do* still have to write code that checks for that, but you do it only when it's displayed in the UI.
>>>
>>>~~Bonnie