SAP Knowledge Base Article - Public

2670615 - How to change Date format from MM/DD/YYYY to DD-MMM-YYYY in Realms?

Symptom

  • Is it possible to change the Date Format from MM/DD/YYYY (07/17/2018) to DD-MMMM-YYYY (17-JUL-2018) in Realms?
  • How to change Date Format in Advance Reporting (Realms)?

Environment

  • Advance Reporting (Realms)
  • Online Report Designer

Resolution

  1. Navigate to Advance Reporting
  2. Select any Date field from any table
  3. Go to Calculated Column Designer 
  4. Give a name to the Calculated Column
  5. Select Data Type as - Date
  6. At the left hand Panel > Click on the Edit Formatting
  7. Select "Use Custom Format String" check box
  8. Custom Format String: dd-MMM-YYYY
  9. Click on OK > Done

Keywords

Advance Reporting, Date Format, Realms, Calculated Column, DD-MMMM-YYYY, dd-MMM-YYYY. , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HXM Core all versions