Loading

Error 'failed to parse date' for Date Time Field with Data Loader

Fecha de publicación: Oct 13, 2022
Descripción
Valid formatting for Date/Time fields in the API are documented in the following resources:

Format the 'Date' and 'Date Time' data in a CSV file
Valid Date Format in Records
Date Formats and Date Literals in WHERE Clauses

It may be necessary to specify or set a timezone outside of GMT or UTC in your data. In this circumstance, it's possible to include a timezone offset in your data such as:

1999-01-01T23:01:01+01:00

Although this is documented as an acceptable format for a Date/Time field in the API, Users may receive the following error when attempting to use Data Loader to insert, update, or upsert:
 
Error converting value to correct data type: Failed to parse date: 1999-01-01T23:01:01+01:00
Solución

Although the Data Loader relies on the SOAP or BULK API, it has its own unique formatting rules in terms of what it can accept for Date/Time values with timezone offset.

Refer to the documentation Data Types Supported by Data Loader for all of the supported formats that are unique to Data Loader.

For the specific example used above:

1999-01-01T23:01:01+01:00

The appropriate formatting may be either:

1999-01-01T23:01:01+0100

OR

1999-01-01T23:01:01GMT+01:00


See Also:
Install Data Loader and other Java considerations
Número del artículo de conocimiento

000383025

 
Cargando
Salesforce Help | Article