SAP Knowledge Base Article - Public

2452580 - Change Date Format in NewHire Export file - Onboarding 1.0

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 SucessFactors Onboarding 1.0

Reproducing the Issue

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

    2017-04-04_incorrect date format.png

 

Resolution

  1. To resolve this issue an change will need to made to the "ExportNewHireDataExport.CSV" file in Super Admin
  2. Please create and case 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

Date, Format, New Hire Export , KBA , LOD-SF-OBD-INT , Integrations with Onboarding , Problem

Product

SAP SuccessFactors Onboarding all versions