SAP Knowledge Base Article - Public

2280731 - Changing the date format in adhoc report

Symptom

Changing the date format in Adhoc report 

Environment

SAP Successfactors

Adhoc Report Builider 

Reproducing the Issue

Create or Run any adhoc report which has the date column inculded

If the business requirement is to show only DD/MM/YY (two digits for the year) instead of the desired DD/MM/YYYY (four digits for the year).

This can be controled from the backend (provisioning)

Date.PNG

 

Cause

The requirement is to change the date format (DD/MM/YYYY) or (DD/MM/YY)

Resolution

 Option "Enable Legacy Date/Time Rendering in Ad hoc" control the behaviour of the date format.

Date2.PNG

 If the option is disabled then the date format will be shown as (DD/MM/YYYY)

1.png

If the option is enabled then the date format will be shown as (DD/MM/YY)

2.png

Please raise an incident with the Successfactor or contact the Implementation Partner to get the desired date format.

 

Keywords

Adhoc Report Date Format  Date format DD/MM/YY , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To

Product

SAP SuccessFactors HCM Core all versions