SAP Knowledge Base Article - Public

2729832 - HireDate Showing Incorrect format/date in SuccessFactors

Symptom

HireDate is showing an incorrect format/date

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Upload Employee Import (UDF) User Data File
  2. Export Employee (UDF) User Data File
  3. HireDate is displaying incorrectly

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

See Also

KB article 2320676 - File Encoding and Impact on Import Jobs. Tips & Tricks from Support

Keywords

Hire Date , date format , date , import , export UDF, US date format, UK date format, PLA-6965, SF, Success Factors, PLT, platform, bizx, biz x , KBA , LOD-SF-PLT-JOBS , Scheduled Jobs , LOD-SF-PLT , Platform Foundational Capabilities , How To

Product

SAP SuccessFactors HXM Suite all versions