SAP Knowledge Base Article - Public

2452580 - Change Date Format in NewHire Export file - Onboarding

Symptom

  • Date  format in NewHire Export is sending at yyyy/mm/dd
  • Require date format is mm/dd/yyyy
  • Dates received are not loading into HRIS system due to the format currently received.

Environment

  • SAP SF ONBOARDING
  • SFTP
  • EXPORT

Reproducing the Issue

  • Export NewHire
  • Pickup file from SFTP
  • Open file in Notepad - check formatting on the dates currently "yyyy/mm/dd"

2017-04-04_incorrect date format.png

 

Resolution

  • To resolve this issue an change will need to made to the "ExportNewHireDataExport.CSV" file in Super Admin
  • Please create and incident in the SAP Support Portal, include this KBA #

To correct this issue, the following should be updated in the "ExportNewHireDataExport.CSV" :

Change:

From: ($year,'/',$month,'/',$day)

To: ($month,'/',$day,'/',$year)

2017-04-04_csv.png

 

Keywords

KBA , LOD-SF-OBD-INT , Integrations with Onboarding , Problem

Product

SAP SuccessFactors Onboarding all versions