>>>I am trying to do a Word Mail Merge with a VFP .dbf free table as my data source. I select dBase files (there is no VFP option) as my data source file type. The merge will not work if the .dbf has a date field. I am assuming that there is a compatibility problem between dBase and VFP dates. Does anyone know how I can create a dBase compatible date in VFP?
>>>
>>>Thanks
>>>
>>>Brenda
>>As far as I know, both dBase and VFP store dates in ASCII characters with DTOS format. Jan 1, 2006 is 8 character bytes "20060101"
>>
>>Are you sure it's a Date field, not DateTime or a character field representing a date?
>
>If my .dbf has a date field, then Word gives me "unable to open the data source". Otherwise it opens the .dbf data source just fine. I selected dBase III file as my data source type. That is why I am assuming it is a conversion issue.

Sorry, I don't have an answer. As a possible work-around, however, could you copy to a FOXPLUS or FOX2X table and see how that works?