The date format "YYYY/MM/DD" in a CSV file changes to "MM/DD/YYYY" when saved via Box for Office.
If there is date data in the "YYYY/MM/DD" format in a CSV file created in Excel, saving it via Box For Office forcibly converts it to the "MM/DD/YYYY" format.
The reproduction steps are as follows:
(1) Launch Excel and create a blank workbook.
(2) Enter a date in the "YYYY/MM/DD" format in a cell.
(3) Click "File" → "Save As."
(4) Click "Browse Box" when saving.
(5) Select any Box folder as the save destination, choose "CSV (Comma delimited)" as the "Save as type," and click the "Save" button.
- Even if you open the saved CSV file in Notepad, it is in the "MM/DD/YYYY" format.
- This occurs in any Box folder used as the save destination.
- It is not converted if saved to a local folder.
1
vote
