I faced the same problem in VFP6.
(When I used append from on an SDF file with a date in it... even if all 4 digits of the year are in the file FoxPro imports it to a date field using the first two characters of the year.)

Thanks,