SAP Knowledge Base Article - Public

2285788 - How to avoid date/time issues when importing via the Import Data Tool


This is a KBA highlighting a common pitfall regarding date/time data when importing via the system's Import Data Tool. A common issue is that the imported date/time field does not reflect the sytem's date/time preference as defined in Date Format Patterns, Locales and Preferences (See Also: KBAs referenced below). A common mistake is to match the time/date format with the preference of the system you are importing the data into. For example, a system utilising an English locale by default has the dd/mm/yyyy date format. Adopting this date format in the import file will result in errors.


Learning Management System (LMS)

Reproducing the Issue

  • Download any of the Import Data Tool templates
  • Populate as required
  • Import File via Import Data function


Regardless of the system's time/date preference (as defined in Date Format Patterns, Locales and Preferences), the import file needs to adhere to the US date/time format: mm/dd/yyyy hh:mm:ss: AM/PM; where time is optional.

The system will then convert this value to the system's defined time/date preference during the import process.

See Also

  • 2074322 - Changing Default Date Format - Learning
  • 2175518 - Learning: How to change Date and Time format?


  • Time/Date Preferences
  • Import Data Tool
  • Default Time/Date Format
, KBA , LOD-SF-LMS , Learning Management System , How To


SAP SuccessFactors Learning all versions