SAP Knowledge Base Article - Public

2699610 - Import learning history - Not a valid date or time in the format 'MM/dd/yyyy hh:mm:ss a'

Symptom

When importing learning history data through the "Import Data" option, the background job fails. Download the erroneous file to check the error log and, in the "Comment" column, is possible to find the following messages:

  • "'Completion Date (*required)' provided in column 'H' is not a valid date or time in the format 'MM/dd/yyyy hh:mm:ss a'".
  • "'Completion Time (*required)' provided in column 'I' is not a valid date or time in the format 'hh:mm:ss a'.".

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

In the LMS admin side, click on:

  1. System Admin > Tools > Import Data >
  2. Action == Import Data > Record Type == Learning History > Import Option == Add > Choose File > Set the Time Zone ID > Submit >
  3. Run the background job immediately or schedule it > Finish >
  4. Background job status == Failed.

Cause

This is due to a wrong date and/or time data inserted in the file.

Resolution

The accepted data and time formats are mm/dd/yyy (00/00/0000) hh:mm:ss AM/PM (00:00:00 AM or PM).

See Also

2449530 - How to Add/ Update learning event History using Import tool

Keywords

import data, learning history, not a valid date or time in the format 'MM/dd/yyyy hh:mm:ss a', failed , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-ADM , Admin Tools , Problem

Product

SAP SuccessFactors Learning all versions