Data Import Dates

Limits for importing data with Data Loader.

The following limits apply to data imported using Data Loader.

Only dates within a certain range are valid. The earliest valid date is 1700-01-01T00:00:00Z GMT, or just after midnight on January 1, 1700. The latest valid date is 4000-12-31T00:00:00Z GMT, or just after midnight on December 31, 4000. These values are offset by your time zone. For example, in the Pacific time zone, the earliest valid date is 1699-12-31T16:00:00, or 4:00 PM on December 31, 1699.

When using Data Loader version 28.0 and later, the maximum field size for imported CSV files is 32,000 characters.

j

Data Loader

When to Use Data Loader

Install Data Loader

Configure Data Loader

Using Data Loader

Data Types Supported by Data Loader

Export Data from Salesforce

Define Data Loader Field Mappings

Insert, Update, or Delete Data Using Data Loader

Upload Attachments

Upload Files and Links with Data Loader

Review Data Loader Output Files

Data Import Dates

View the Data Loader Log File

Configure the Data Loader Log File

Run in Batch Mode (Windows Only)

Command-Line Quick Start (Windows Only)

Data Loader Third-Party Licenses

Previous Versions