SAP Knowledge Base Article - Public

3649348 - Error "effectiveStartDate: 01/01/1800 is not a valid date value" when deleting records via Import/Export in SuccessFactors

Symptom

Error message: "effectiveStartDate: 01/01/1800 is not a valid date value" is received when attempting to delete a record dated before 1900 via Import/Export feature.

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

  1. Log in to the system
  2. Via Import/Export feature upload a CSV file to delete a record with the effective start date set to 01/01/1800, or earlier.
  3. Observe the error message: "effectiveStartDate: 01/01/1800 is not a valid date value."

Cause

The backend system enforces a restriction where the smallest acceptable date for records is 01/01/1900. This validation is not performed in the user interface, leading to inconsistencies when attempting to delete records with older dates via Import/Export.

Resolution

The system only accepts records with dates from 01/01/1900 onwards but does not validate this restriction in the user interface.

To resolve the issue and complete the Import/Export, follow the steps:

  1. Update the effectiveStartDate of the record to a date after 01/01/1900 (e.g., 01/01/1901).
    1. Ensure the new date does not conflict with other existing records.
  2. Retry the deletion process for the updated record.

See Also

  • KBA 3500785 - Resolving MDF Data Import Errors: Date and Time Formats
  • KBA 2405802 - Date Format Error While Importing Foundation Data or MDF Record

Keywords

effectiveStartDate, 01/01/1800, invalid date value, sap successfactors platform, import/export error, mdf data, date restriction, backend validation, date format error, record deletion, 01/01/1900, error message, sf, platform , KBA , LOD-SF-PLT-PCK , Picklist Management Issue , Problem

Product

SAP SuccessFactors HCM Suite all versions