SAP Knowledge Base Article - Public

2739456 - Incorrect display of date fields after live profile import for background portlet

Symptom

While trying to import background data e.g. Previous Work Experience block, the date is displaying incorrect values.

Environment

SAP SuccessFactors Employee Profile

Reproducing the Issue

When user is trying to import background data i..e. Previous Work History portlet the date is displaying incorrect values.

2222.png

Cause

Incorrect locale was selected while performing the import

Resolution

When the user selects the correct locale while performing the live profile import the date fields display the values correctly.

User can switch to different languages and then the UI will automatically adjust the date field values.When language is US, the date field displays Jul 30, 2018,       while changed to UK, it displays 30 Jul 2018.

 The language can be configured at:

 1111.png

Summarizing different scenarios and their results,

Scenario 1:
Option | Change Language | English (UK) + Import Extended User Information | select UK locale + Import UK date format csv file => import success

Scenario 2:
Option | Change Language | English (UK) + Import Extended User Information | select UK locale + Import US date format csv file => import fail with error message to tell the date format is wrong if the date in csv file cannot be parsed by UK format; Otherwise, the import success BUT the date will be wrong because it parsed in UK format, for example: 
Jan 4 vs Apr 1

Scenario 3:
Option | Change Language | English (UK) + Import Extended User Information | select US locale + Import UK date format csv file => import success BUT the date will be wrong, because the application could parse the date twice, 1st time to parse it as US format, if failed it will parse it 2nd time with UK format. for instance, (UK: startDate,endDate - 01/04/2013,29/04/2013), this will result in:
Jan 4 (1st parse) ~ Apr 29 (2nd parse, because 1st parse failed)

Keywords

Wrong Locale, Incorrect Date Fields, Date Field showing wrong value, Import, Live Profile Import, Background Data Import, Import Extended User Information, Date Field, Wrong Date, Wrong Field Value , KBA , LOD-SF-EP-BGD , Background Elements , LOD-SF-EP-TRD , Trend Elements , Problem

Product

SAP SuccessFactors HXM Suite all versions