Hi!

I prefere to use NULL too. When talk about VFP, I set up NullDisplay property of control to '//' that will display NULL date as pretty empty date ;)


>I second that.
>
>>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