date format in csv export
Accepted answer
Answer to my own question...
For Eclipse you need to edit the Eclipse.ini file in the same folder as your Eclipse.exe. You need to add the following 2 lines under the '-vm' flag:
-Duser.language=en
-Duser.region=GB
I had tried this, but was using -Duser.region=UK which didn't work.
with the GB the date outputs to screen as d Mmm yyyy (instead of 'Mmm d, yyyy') and exports to CSV as yyyy-mm-dd which is recognised by Excel as a date. Happy Days.
2 other answers
Can I re-open this topic...
I have recently changed to a Win 7 machine running Eclipse Client v3.0.1.1. My work item queries now produce dates in format 'Mmm d, yyyy' (e.g. Oct 11, 2012...). Exporting to CSV yields the date in the same format... this is not recognised as a date by Excel and thus interpreted as a string... highly annoying.
I've tried fiddling with Locales via the eclipse.ini file to no avail. (Changing language from en_US to en_UK worked to solve this problem in the Browser client).
As such I'm pretty much unable to perform meaningful exports from my Eclipse Client on this machine where I have to depend on the date columns.
My Regional settings are ignored - the 'Mmm d, yyyy' format is not evident anywhere in my system config.
Connecting to the same project area via Eclipse from a different machine yields output date formats that are recognisable by Excel (generally yyyy-mm-dd formats).
Can anyone advise how I can configure the Eclipse Client to determine the format that dates display on my Work Items and in my exports?
(P.S. The above solution does not work for me... Excel doesn't recognise YYYY-MM-DDtHH:MM:SS:MMMh either due to the 't' in the middle and 'h' at the end).
Thanks
RD