SAP Knowledge Base Article - Public

3090296 - Start Time and End Time fields of EmployeeTime and EmployeeTimeSheet Report showing Time Stamp 1/1/1970

Symptom

In 2021 Release, the Time fields from EmployeeTime and EmployeeTimeSheet objects in Advanced Reporting and Report Story are showing Time Stamp 1/1/1970.





Environment

SAP SuccessFactors HCM Suite
Report Canvas - Advanced Reporting
Report Story
People Analytics

Reproducing the Issue

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
1. Run any Report Canvas or Report Story that has Employee Time table added on its query
2. Observe that result for Start Time and End Time column has date added "1/1/1970





Cause

Employee Time objects got migrated from MDF Legacy to MDF BE as part of 2021 releases. This migration introduced a dummy date along with the Time value.

Resolution

Engineering team is investigating this issue, but there is no fix date at the moment. 
Please note that the time value displayed in the fields is still correct and the date of 1/1/1970 can be disregarded.

Workaround for Report Canvas - Advanced Reporting

  1. Edit the Advanced Reporting query
  2. Create a calculated column
  3. Select the field StartTime or EndTime
  4. In the formula, click on the field
  5. Add function
  6. Use the Right function and set 8 characters

The date of 1/1/1970 is removed, but note that the time value will be displayed as 24h format.

For Story reports, follow the steps as outlined in this blog

See Also

2718538 - Substring Function for Calculated Columns - Online Report Designer

3204317 - Date field cannot be converted to string in Story report



Keywords

2021 Release 2105 2111 issue Start Time and End Time fields of EmployeeTime EmployeeTimeSheet Time Stamp 1/1/1970 report, KI2111, MDF-45628, AYT-43964, KI2205, Report Story, People Analytics, KI2211, time , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Suite all versions

Attachments

Pasted image.png
image.png