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

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

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

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

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.

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. 

2718538 - Substring Function for Calculated Columns - Online Report Designer

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

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