SAP Knowledge Base Article - Public

3573160 - Date Format in Table Report for Custom Employee Profile Field

Symptom

  • The date format of a custom Employee Profile field (e.g. custom10) is not displaying as desired (dd/mm/yyyy) in a table report.
  • The issue occurs when a standard HRIS date field (e.g. Seniority date in EC) is mapped to a custom string field (e.g. custom10 in EP).
  • The date format appears as dd/mm/yyyy in the EC report but as yyyy-mm-dd in the EP report.

Environment

SAP SuccessFactors Employee Central

Reproducing the Issue

  1. Current Date format selected for DATE fields in the instance is 'dd/mm/yyyy'.
  2. Map a field between a standard HRIS date field (e.g. Seniority date in EC) to a custom string field (e.g. custom10 in EP).
  3. Generate a table report with both fields included in Ad-hoc reports -> Employee Profile.
  4. Observe the date format appears differently as 'yyyy-mm-dd' and not as expected, 'dd/mm/yyyy'.

Cause

  • This is expected behaviour.
  • This would not be considered a defect, as we cannot presume to know how these custom fields will be used in each instance, to meet specific business scenarios.

Resolution

  • The difference in format arises because the custom field in the Employee Profile is designed to store extra user information and is of string type. Therefore, the values in the custom field are treated as a normal string instead of a date type, with no format involved.
  • As a result, the date format in the custom field will be inconsistent with the standard HRIS date field, because the custom string field is not a date type data field.
  • If you wish to see the behaviour of this feature changed, please consider opening an enhancement request via 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products - SAP for Me .

See Also

2498557 - Date format is inconsistent between CSV exports from Table reports / Canvas reports - SAP for Me

Keywords

Employee Profile, Table Report, Date Format, Custom Field, Standard HRIS date field, Inconsistent Date Format, custom string, user information data, HRIS sync. , KBA , LOD-SF-EP-REP , Ad Hoc Report (Employee Profile) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-EC-REP , Reporting Data (EC core only) , Product Enhancement

Product

SAP SuccessFactors Employee Central all versions