I have set century on and set date to american and trying to append a text file with two fields like:

01/01/200002/01/2000
02/01/200002/02/2000

into a table with 2 date fields
d_start d (8)
d_end d (8)

and issue the command: append from temp.txt type sdf.

VFP results with :

rec #1
d_start = 01/01/0020
d_end = 01/02/2000

rec #2

d_start = 02/01/0020
d_end = 02/02/2000

Why is the first field turns into 0020 as year and 2000 on the second record?

Help appreciated.