>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?
>
Y2KFOX for FPDOS at least addresses this quite neatly; it's not free, but it works and works well without having to change your existing code (unless you've done something truly heinous like building dates in strings and forcing the dates to be prepended with 19 to make a 4 digit date, or fix reports when you've hard-coded ", 19" as part of the formation of the date output field.
Other than that, a rewrite to read line-at-a-time with low-level file I/O, followed by APPEND BLANK/REPLACE or INSERT INTO are the obvious lines of attack. Neither approach is terribly arduous.
>Thanks,
>BOb