Symptom
- The completed date under the Assessments Portlet in applicant workbench is showing the incorrect value 1970.
- The Status Date property under JobApplicationAssessmentReport entity in Integration center shows the incorrect value 1970.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
Scenario A:
- Go to applicant workbench.
- Select the candidate who has finished the assessment.
- under the assessment portlet, completion date shows incorrect values 1970 which is earlier than assessment initiate date.
Scenario B:
- Go to Integration center.
- Select JobApplicationAssessmentReport entity.
- Select "Status" and "Status Date".
- Find the value in Status is "Completed" while value in Status Date shows incorrect values 1970 which is earlier than assessment initiate date.
Cause
This is caused by inputting incorrect date format for property which type is DateTimeOffset.
Resolution
When the Assessment vendor are notifying SuccessFactors of the completion of an interview to provide back the Assessment Result, they send below request via ODATA API:
- { "__metadata": { "type": "SFOData.JobApplicationAssessmentReport", "uri": "JobApplicationAssessmentReport" }, "orderId": "123", "reportURL":"***", "status": 0, "statusDate": "/Date(1704189306)/" }
The input value for statusDate in the request is incorrect. The property type of "statusDate" in JobApplicationAssessmentReport entity is datetimeoffset, not datetime. datetimeoffset store time values in UTC time zone while datetime fields store values in the DC server's local time. So the correct input date format in the request should be "/Date(1704189306000+0000)/" .
If input the wrong date format like "/Date(1704189306)/", the system will automatically recognize the last four digits as offset. So the system shows a completed date of "/Date(170418+9306)/" which equals to 01/20/1970.
See Also
2933028 - Using the DateTimeOffset and DateTime Formats - OData API
3091624 - Wrong Dates in Integration Center - Recruiting Management
2876414 - How Assessment Integration Works (Event Subscription) - Recruiting Management
Keywords
DateTime, DateTimeOffset, UTC, DateTime format, Date time, Date time offset, Assessments, Completed date, Job application , KBA , LOD-SF-RCM-ASI , Assessment Integration , LOD-SF-RCM-INT , Integration Center & Intelligent Services , LOD-SF-RCM-API , Webservices & APIs , Problem