Terry,

I prefer to use NULL for an empty date. But, to each his own.

>Okay, I'll use that date as my empty then.
>
>Thanks again.
>Terry
>
>>No there isn't. If you insert empty date from QA it gets converted to 01/01/1900.
>>
>>>So as to not have a null date field, is there an empty date value like '' for string or 0 for numeric or decimal that can be used as a default value for a field?
>>>
>>>Something better than using an old date like 1/1/1800?
>>>
>>>Thanks
>>>Terry