CSV Import gives wrong dates in Region 'French(France)' as the date format is not supported by RTC.
Accepted answer
Bonjour Shreya,
Unfortunately there is no specification for the CSV format apart from RFC 4180 (http://tools.ietf.org/html/rfc4180) which does not specify how dates should be formatted. The problem of date format also applies to exporting dates from RTC to CSV and importing them to Excel. See:
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=354917
The only solution is to format the dates correctly before the import. If you are using Excel this is easy with the Format Cell function or using a macro. You should choose either the American format or the more universal ISO 8601 format :
https://en.wikipedia.org/wiki/ISO_8601
i.e. yyyy-mm-dd
Enjoy, Simon
Unfortunately there is no specification for the CSV format apart from RFC 4180 (http://tools.ietf.org/html/rfc4180) which does not specify how dates should be formatted. The problem of date format also applies to exporting dates from RTC to CSV and importing them to Excel. See:
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=354917
The only solution is to format the dates correctly before the import. If you are using Excel this is easy with the Format Cell function or using a macro. You should choose either the American format or the more universal ISO 8601 format :
https://en.wikipedia.org/wiki/ISO_8601
i.e. yyyy-mm-dd
Enjoy, Simon