Date format incorrect on CSV user upload

Issue symptoms

When bulk importing users into Zendesk Support through comma-separated values (CSV) upload, the date format is incorrect. Microsoft Excel changes the date format. I enter dates in dd/mm/yyyy format, but Excel changes the year to two digits instead of four. For example, I enter 08/09/2016 into Excel, which changes it to 08/09/16. Zendesk Support then displays "September 8, 16" on the user profile.

Resolution steps

The correct date format is dd/mm/yyyy. By default, Microsoft Excel changes the year from four digits to two. Change the format to include all four digits when you save your file.

To change date formatting in Microsoft Excel:

Open your file in Microsoft Excel

Follow the instructions in the Microsoft support article to change the date format

Ensure the locale is United Kingdom (English)

Select a format that shows the date in the dd/mm/yyyy format

Alternatively, create the CSV file in Google Sheets, which doesn't change the date format.