Format 'Date' and 'Date Time' fields for import with the Data Import Wizard

How to Fix Date and Date/Time Format Errors in the Data Import Wizard

To resolve the import error, set the Date and Date/Time field values in your CSV file to match the format that corresponds to the locale of the user running the import.

Step 1: Check the importing user's locale

1. In Salesforce, navigate to Setup.
2. In the Quick Find box, type Users, then select Users.
3. Click the name of the user who will run the import.
4. Note the Locale value shown on the user detail page.

To change the locale, click Edit, update the Locale field, and click Save. See Edit Your Language and Locale Settings for full instructions.

Step 2: Format your Date and Date/Time values correctly
Date and Date/Time values in the CSV must match one of the following formats:

• In the "DATE AND TIME FORMATS" column for the importing user's locale as outlined in the Locale's Supported Date and Time Formats (ICU) documentation. The date and time formats outlined in the documentation above are only applicable to orgs that have ICU locale formats enabled. See Determine Whether Your Org Uses ICU or JDK Locale Formats for more details.
  
  (OR)
• As outlined in the Valid Date Format in Records documentation since the Data Import Wizard uses the BULK API.

Note

• For a Date field: include only the date portion (not time).
• For a Date/Time field: include both date and time portions.