SAP Knowledge Base Article - Public

2729832 - HireDate showing incorrect format/date

Symptom

HireDate showing incorrect format/date

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

Step 1: Upload Employee Import (UDF) User Data File

Step 2: Export Employee (UDF) User Data File

Step 3: HireDate is displaying incorrectly

Cause

 File date formats must be mm/dd/yyyy.

Resolution

SF Supports the following date formats for Employee Import:

  1. "Month/Day/Year" format should be  "11/23/2018" (This is US date format "default")
  2. "Day-Month-Year" format should be  "23-NOV-2018"  (This is UK date format)

WARNING: If you open the file in MS Excel, MS Excel may translate dates into the mm/dd/yyyy - It is recommended to use a text editor when working with imports.

Note : For more details on File encoding reference KBA: 2320676 - Platform - File encoding and impact on import jobs. Tips & Tricks from Support 

Keywords

HireDate , Hire Date , format , incorrect , date format , date , format , import , export UDF , US date format . UK date format , PLA-6965 , KBA , LOD-SF-PLT-JOBS , Scheduled Jobs , LOD-SF-PLT , Foundational Capabilities & Tools , How To

Product

SAP SuccessFactors HCM Suite all versions