I found this out from a client today. If you use 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 (century) as the year, and ALL dates have a 19 as century.

Is there a way to make this work? I know there are other methods I can use, but I want to know if it is possible to make APPEND FROM work?

Thanks,
BOb