Symptom
Excel returns "#########" value for Start and/or End dates that appear to be not in its accepted format (01/01/1900), when generating an Excel file from Goal Management table report.
Environment
SAP SuccessFactors Performance & Goals
Reproducing the Issue
- Create a Goal Management table report with goal start date added as column in it.
- Generate the Excel file.
- See that Excel returns "#########" for dates that are not in its accepted format (01/01/1900).
Cause
Start and/or end dates for goals are not being captured in the correct way (for example Jan 1, 0024 instead of Jan 1, 2024) and this leads to "#######" value showing up when exporting report data to Excel.
Resolution
Edit the affected Goal's Start/End date to the desired value by using the built-in calendar tool in Goal Management.
Keywords
SuccessFactors, SF, ######, adhoc, table, value, report, goal, start date, end date, format, range, incorrect, built-in calendar, edit, date , KBA , LOD-SF-GM-ADM , Admin Tools, Settings, Permissions , LOD-SF-GM-REP , Reporting and Data Imports Exports , Problem
SAP Knowledge Base Article - Public