SAP Knowledge Base Article - Public

2572329 - Job Information Import contains Invalid Date Format

Symptom

When trying to import your Job Information csv file the system throws an error.

Environment

SAP SuccessFactors Employee Central: Employee Data Import

Reproducing the Issue

  1. Go to Admin Centre
  2. Open Import Employee Data
  3. Select Job Information, choose your file
  4. Click on validate import file data

Error:

2017-11-30_12-13-59.jpg

Cause

The date format, on (at least) one of the dates in the file, is incorrect.

To confirm the correct date format: go to Admin Centre, choose Employee Export,

in this export file (csv) find your user and look up the DEFAULT_LOCALE field value.

e.g. For en_GB it is dd/MM/yyyy

 

You can also change the locale language for the import of this file only by going into

Import Employee Data, and changing the value of the File Locale, here you will see the format appearing below the country selected

2017-11-30_13-35-43.jpg

Resolution

Make sure the date format is correct for your locale language.

Keywords

invalid Date format, import, import error. , KBA , LOD-SF-EC-JOB , Job Information , Problem

Product

SAP SuccessFactors Employee Central all versions