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