SAP Knowledge Base Article - Public

2877490 - Employee Import Failing - Date/time value out of range

Symptom

Employee Import failing with error in Job Details - "Date/time value out of range"

Environment

SAP SuccessFactors HCM Suite

Reproducing the Issue

When creating a UDF file to import new users or update existing users

 - In the Hire Date or Exit Date column

 - Add the hire date or exit date as normal but also add a time stamp of hh:mm:ss

 - Import the file - note it will fail with the error -  Date/time value out of range

Cause

The system only processes the date and not the time.

Issue only started after 1911 release for customers who prviously had a time in the hire date/ exit date column

The expected behavior for hiredate/exitdate is that only date can be recorded into system DB. System only process date not time.

Before b1911

For example, when the date being processed, it will catch the 'MM/DD/YYYY' only and skip later content like 'HH,MM,SS'

After b1911

To improve and support more locale date format, we add some logic to detect/prevent space issue for later content. E.g, let "DD/MM/YYYY  " equal to "DD/MM/YYYY". However, if customer add some error content after date, it will cause date out of range.

Resolution

Remove the time from the hire date and/or exit date column in the import file

 - This will need to be done by the product/system which is populating and placing the import file on the SFTP server, for scheduled import jobs

Although hiredate/exitdate only support date without time and skip later content, we also think it is necessary to extend tolerance on these fields. B2005 will fix and prevent this issue. The workaround could be let customer remove time on hiredate/exitdate and re-import again.

Keywords

Employee Import, Date/time value out of range, UDF , KBA , LOD-SF-PLT-UIM , Employee Import Issues , Problem

Product

SAP SuccessFactors HXM Core 1911 ; SAP SuccessFactors HXM Suite all versions