Symptom
You are running SFAPI CompoundEmployee queries like the sample below and you are getting the respective error in the response.
The query executed was in FULL MODE and you observed this error in 2H 2020 (b2011) release.
Request:
- SELECT person,email_information,employment_information,job_information,personal_information FROM CompoundEmployee WHERE last_modified_on>=('2020-10-01T00:00:00Z')
Response:
- Invalid SFQL! Error: Invalid WHERE clause. Function "to_Date" or "to_DateTime" is necessary for "last_modified_on". Usage Example: to_date('01/07/20', 'DD/MM/YY') or to_DateTime('2020-06-07T01:00:00Z')
Read more...
Environment
- SAP SuccessFactors HXM Suite
- CompoundEmployee API in Full Mode
Product
SAP SuccessFactors HCM Suite all versions
Keywords
- Invalid SFQL! Error: Invalid WHERE clause. Function "to_Date" or "to_DateTime" is necessary for "last_modified_on". Usage Example: to_date('01/07/20', 'DD/MM/YY') or to_DateTime('2020-06-07T01:00:00Z'), SFAPI CompoundEmployee, CE, SFAPICE, 2H 2020 SF release, b2011, 2011, query, full mode, delta, last_modified_on
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.