>It seems that when you use the command APPEND FROM
TYPE SDF that VFP6 does not behave like VFP5. All date field that are appended do not use the set century, rollover, information. Example: input date = 12/12/99, what you get in your date field after the append is 12/12/0099. This command work properly in VFP5 and definitely does not work in VFP6.
>
>Is these any work around for this???
Dates imported via SDF in the form YYYYMMDD are handled correctly; I tend to massage dates into this format to get a reliable date for the append TYPE SDF or DELIMITED; alternatively, pull them in as strings and use CTOD() to convert them after doing appropriate SET CENTURY things; you can STUFF the DTOS(CTOD()) of a MM/DD/YY formed date back in place of the MM/DD/YY value to fix it up. For example if you had an 80 character record terminated with a CR/LF pair, with a MM/DD/YY date starting at position 10 of each record, the following would fix up things nicely:LOCAL cFileAsString, nPosInFile, nStringLen
#DEFINE RECLEN 82
#DEFINE DATELEN 8
#DEFINE DATEOFFSETPOSINREC 10
cFileAsString = FILETOSTR('test1.txt')
nPosInFile = DATEOFFSETPOSINREC
nStringLen = LEN(cFileAsString)
DO WHILE nPosInFile + DATELEN < nStringLen
cFileAsString = STUFF(cFileAsString, nPosInFile,DATELEN,DTOS(CTOD(SUBST(cFileAsString,nPosInFile,DATELEN))))
nPosInFile = nPosInFile + RECLEN
ENDDO
=STRTOFILE(cFileAsString,'FileOut')
