Symptom
You are querying data using the last_modified_on or snapshot_date fields of the Employee Central CompoundEmployee API from more than 3 months in the past and receive the below error:
DATE_EXCEEDS_RESTRICTION, errorMessage: Invalid date: last_modified_on field value "yyyy-MM-dd" exceeds restriction of 3 months into the past. The earliest date you can use is "yyyy-MM-dd"
Environment
SAP SuccessFactors Employee Central
Cause
Queries that pull data from the last_modified_on or snapshot_date fields of the Employee Central CompoundEmployee API are now restricted to a maximum of 3 months in the past in ALL instances - preview and production. This improvement increases the performance and enables faster synchronization between Employee Central and target systems.
You may refer to Restrictions on the API Fields for the Last Modified Date and the Snapshot Date
Resolution
As this is a expected behavior, the only possible solution is to change the date used in the fields last_modified_on or snapshot_date fields so that the date is not longer than 3 months in the past.
See Also
Keywords
Compound Employee, CE, DATE_EXCEEDS_RESTRICTION, restriction, 3 months , KBA , LOD-SF-INT-CE , Compound Employee API , Problem