Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd Date behavior with CSV file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00680833
Message ID:
00680836
Views:
23
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform