Symptom
- Not able to use date functions in calculated column using a date field.
- Not able to change the date format using a calculated column.
Environment
- SAP SuccessFactors HXM Suite
- Report – Canvas
- Detailed Report
- Advanced Report
Reproducing the Issue
- Create/Edit any canvas report;
- Using the calculated column feature try to perform a date calculation in a field which has date records;
- Realize that there is no date functions available.
Cause
The selected field which is storing date records is not set as a date field.
Resolution
In order to the date functions be available in the calculated columns, the field used to be calculated should be set as a date field.
If the field not date field and it is string for example, the functions will not be available by expected behavior.
See Also
Keywords
Calculated; Column; Date; Fuction; Formula; Format; Record; Data; Field; Store; Load; Change; String; Int; Const; Text; Float; , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To
Product
SAP SuccessFactors HCM Suite all versions