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
- Log in to the system
- Via Import/Export feature upload a CSV file to delete a record with the effective start date set to 01/01/1800, or earlier.
- 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:
- Update the effectiveStartDate of the record to a date after 01/01/1900 (e.g., 01/01/1901).
- Ensure the new date does not conflict with other existing records.
- Retry the deletion process for the updated record.
See Also
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
SAP Knowledge Base Article - Public