Date format incorrect on CSV user upload

Issue symptoms

When bulk importing users into Zendesk through CSV upload, the dates are formatted incorrectly. Microsoft Excel changes the date format. I enter dates in dd/mm/yyyy format but Excel alters the year to be two digits instead of four. For example, I enter 08/09/2016 into Excel which it then changes to 08/09/16, and consequently, Zendesk displays "September 8, 16" on the user profile. 

Resolution steps

The appropriate formatting for dates is dd/mm/yyyy. By default, Microsoft Excel changes the number of digits in the year from four down to two. Modify the formatting so that all four digits are included when saving your file.

To modify date formatting in Microsoft Excel

1. Open your file in Microsoft Excel.
2. Follow the instructions from this Microsoft's article to change the date format.
3. Ensure the Locale (location) is United Kingdom (English).
4. Select formatting that shows the date in the dd/mm/yyyy format.

Alternatively, create the CSV in Google Sheets, which does not alter the formatting of dates.

For additional help with date formatting in Excel, refer to the Microsoft help center.