SAP Knowledge Base Article - Public

3417770 - Assessment is completed with unexpected Status Date of 1970 - Recruiting Management

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:

  1. Go to applicant workbench.
  2. Select the candidate who has finished the assessment.
  3. under the assessment portlet, completion date shows incorrect values 1970 which is earlier than assessment initiate date.

Scenario B:

  1. Go to Integration center.
  2. Select JobApplicationAssessmentReport entity.
  3. Select "Status" and "Status Date".
  4. 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

Product

SAP SuccessFactors Recruiting all versions