SAP Knowledge Base Article - Public

3245889 - Story Report - CURRENTDATE() function is not working

Symptom

CURRENTDATE() function does not work and current date function will always return blank in Story

Environment

  • SuccessFactors HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • People Analytics (Analytics Cloud for SF)
        • Query Designer - Filter, Calculated Column, Params

Reproducing the Issue

  1. Login to the instance
  2. Navigate to Reporting
  3. Click the New > select Story
  4. create a story report with columns having date field
  5. Now try to add calculated column and use CURRENTDATE() function.
  6. CURRENTDATE() do not work as expected (eg: Compare any Date field added in the query to currentDate, data will not be fetched as expected, since CURRENTDATE() function does not work at the moment.

Cause

There is a defect filed with SAC Product Team

Resolution

Need to look for any workaround as per customer requirement. 

 

For a case we handled, customer were trying to compare IF(TERMINATION DATE = CURRENTDATE(), 'Equal', 'Not Equal')

As CURRENTDATE() returns null, the output was always 'Not Equal'.

Workaround provided was to set a filter TERMINATION DATE is equal to (dynamic variable) CURRENTDATE. 

 

CURRENTDATE works in Filters.

Keywords

CURRENTDATE, CURRENTDATE(), Date, calculated column, date function, Stories, Story, People, analytics , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , People Analytics (Analytics Cloud for SF) , Problem

Product

SAP SuccessFactors HXM Suite 2205