SAP Knowledge Base Article - Public

2948495 - Not able to calculate date field in calculated column – Canvas Report

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

  1. Create/Edit any canvas report;
  2. Using the calculated column feature try to perform a date calculation in a field which has date records;
  3. 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

2726015 - Changing Date Display Format in Online Report Designer or Report - Canvas

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 HXM Suite all versions