>If I create a cursor and put in two dates then copy those to a CSV file, shouldn't they come back as the same date when appending? Check out this code and tell me why it is behaving the way it is.
>
There is inconsistent behavior with the way that fox puts dates into a CSV file and what it expects the date to look when it copies from a CSV.
The date must be in the YYYYMMDD format or Fox will choke.
If you don’t need the field names in your text file, you could use an SDF or write the COPY TO command yourself. There is not even a SET DATE TO ??? that gives you the needed format! Must be part of the new release.
Chris