Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dates gone wild
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Dates gone wild
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01059314
Message ID:
01059314
Views:
56
Today I am really stuck with a simple problem.

I re-wrote an application we have in Fox 2.6 that in the end it created a text file we send to another company. We created this text file using, at the end of the process a line like:
copy to (lcDestFile) fields update, uptime.... delimited
Now if you look at the text file you'll see something similar to

20051025,"06:10:28", .....

If you do the same with VFP 9, what you get is:
10/25/2005,"06:10:28", .....

Were The format of the date will depend on the settings of SET("DATE"), so the question is what is the easiest way to accomplish this, without writing a whole program (that I would start writing after I get my lunch)

I tried
select dtos(update) as update, uptime, ... into cursor somecursor
copy to (lcDestFile) fields update, uptime.... delimited
but then i got

"20051025","06:10:28", .....

Any ideas of what I am missing here?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Next
Reply
Map
View

Click here to load this message in the networking platform