csv array date formats

[nickedw]

I have several date columns which are included in a csvarray export.
One date column is formatted as " yyyymm" eg 201311
Another date column is formatted as yyyy-mm-dd eg 2013-11-30
After doing a csvarray export these date columns has the format mm/dd/yyyy eg 11/30/2013
here is an excerpt from the csv array output:
"(11/30/2013","145814.0","11/5/2013","11/5/2013",....
Is there a way to tell Winbatch to keep the excel format, or format using Winbatch?

Thanks for all help

[stanl]

I discovered over time that when converting custom Excel formats to flat files the clipboard works best, or use Excel's XML functions. With the clipboard you get TAB-delimited not csv, but that can be worked around.

[DAG_P6]

The Excel export to CSV converts dates to the Short Date format set in the Windows Control Panrel, which is usually mm/dd/yy or mm/dd/yyyy.

With respect to the clipboard giving you TAB delimited records, that should be just dandy for WinBatch, since the default list delimiter happens to be at TAB. However, if I intend to do much with the contents of such a list, I usually convert it into an array. The initial conversion is fairly quick, and required but one statement. Once cinverted, array operations are very fast and efficient.

On the other hand, I am not very fond of XML, because the format is bloated and computationally expensive to process.

[td]

On the other hand, I am not very fond of XML, because the format is bloated and computationally expensive to process.

Not at the top of my list of favorite standardizations either.