>>>I have a question regarding dates in Visual FaxPro 5.0. Is there a way of storing dates (as 'date' not 'char') that have 1 or 2 out of
>>>date/month/year missing; e.g. dates like 11/27/0000, 00/00/1901,
>>>12/00/1788?
>>>
>>>Thanks Austin
>>
>>No.
FoxPro requires valid dates or else it is not a date.
>
>Are there any tricks to get around this problem for me.
The only thing I can think of is to use character strings for dates. But you said you didn't want to do that. Or maybe you could break it down into 3 numeric fields, year, month, day. (if you do this, be sure to change the names so that they are not the same as the VFP reserved words) Any way you do this is going to take some massaging on your part, because a "date" variable can only exist as a complete value (year, month and day).