>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?

select INT(VAL(dtos(update))) as update, uptime, ... into cursor somecursor
copy to (lcDestFile) fields update, uptime.... delimited