SAP Knowledge Base Article - Public

3247813 - Empty records or Syntax error in ADDDAYTODATE function in Story Report

Symptom

Empty records or error appears if Code Syntax AddDayToDate(date,periods), periods statement contains any field or dynamic field, calculation, e.g.,:

  • ADDDAYTODATE([Employment#Job Information#Employment Created Date], 3) gives an empty fields
  • ADDDAYTODATE([Employment#Job Information#Employment Created Date (Timestamp)], 3) even gives a syntax error (Formula could not be computed: ADDDAYTODATE([Employment#Job Information#Employment Created Date (Timestamp)], 3). Try rewriting the formula.)
  • ADDDAYTODATE([Employment#Job Information#Hire Date], [Test Calculated column]) where [Test Calculated] is a calculated column of type “Measure” gives a syntax error (Formula could not be computed: Incorrect parameters specified for function "AddDayToDate". There is no matching signature. Try rewriting the formula.)
  • ADDDAYTODATE(CURRENTDATE(), {Number}) provides always an empty column

Environment

SAP SuccessFactors HXM Suite

Report Center - Story Report

Reproducing the Issue

  1. Create a calculated column with ADDDAYTODATE
  2. Add any non-static argument to periods section in the syntax
  3. You can see either empty records/error sytanx

Resolution

This issue is currently under investigation by SAC development.

Keywords

Calculated column, ADDDAYTODATE, CURRENTDATE, (Formula could not be computed: Incorrect parameters specified for function "AddDayToDate". There is no matching signature. Try rewriting the formula.), Formula could not be computed: ADDDAYTODATE, empty record, blank field, blank record, report story , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Known Error

Product

SAP SuccessFactors HXM Suite Core 2205