Hi Bob,

>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.

This is really strange!

Everyone here seems to confirm what you are seeing. When I wrote my Y2K article this was one of the things that worked perfectly in FoxPro 2.6 DOS and Windows. No matter whether SET CENTURY is ON or OFF, APPEND FROM TYPE SDF added a 4 digit year, when the SDF file contained 4 digits. Only when the source file had only 2 digits, VFP assumed 19xx as the century, but that's impossible with SDF files.

Therefore I just tested this again, and it still works. Could the difference be that I'm running FP 2.6 and you probably 2.6a? Unfortunately, there was no German 2.6a, therefore I can't test here. Here's my test code:

SET CENTURY OFF
USE SYS(2005) AGAIN
COPY TO Tmp.DBF
USE Tmp.DBF EXCL
REPLACE Updated WITH GOMONTH(Updated,1200) ;
  FOR MOD(RECNO(),2) == 0
COPY TO Tmp.TXT TYPE SDF
ZAP
APPEND FROM Tmp.Txt TYPE SDF
SET CENTURY ON
BROWSE

Christof