Tweet
When a Test Case or set of test Cases are exported imported to a .csv file then imported again the month-days are reversed. ie. date in .csv is 10/2/2007 it is imported as 10-Feb-2007.
-
-
The expected date format when importing is either YYYY-MM-DD or DD/MM/YYYY. YYYY-MM-DD is the recommended format as it is the international standard date format. -
Agreed and understood. However the export is in the format of DD-MM-YYYY and the import is in the format MM-DD-YYYY. How can I change the import function?Comment
-
If this was a CSV exported from TestLog it should have been in YYYY-MM-DD format. If it has been opened after the export or created in Excel it's likely the date format defaulted to your computer local.
You should be able to change the format back in Excel by selecting the cells, choosing format cells from the right click menu, clicking on the Date category and choosing the YYYY-MM-DD option from the type list (shown as 2001-03-14 in Excel 2003).Comment
Comment