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
- Open your file in Microsoft Excel
- Follow the instructions from this Microsoft's article to change the date format
- Ensure the Locale (location) is
United Kingdom (English) - Select formatting that shows the date in the
dd/mm/yyyyformat
Alternatively, create the CSV in Google Sheets, which does not alter the formatting of dates.