Use Supported Date Formats

In Dataloader from MuleSoft, imports accept American (MM/DD/YYYY) and European (DD/MM/YYYY) date patterns, depending on your settings. Use a supported format in your CSV files to make sure date fields process correctly.

• MM/DD/YYYY (example: 04/23/2012)

• DD/MM/YYYY (example: 23/04/2012)

• YYYY-MM-DD (example: 2012-03-25)

• Military time zones: MM/DD/YYYYThh:mm:ss.mmmZ (example: 02/20/1987T12:04:12.000Z)

• Three-letter time zones with offset: MM/DD/YYYYThh:mm:ss.mmmXXX+hh:mm (example: 02/20/1987T12:04:12.000GMT+03:00)

• Three-letter time zones: MM/DD/YYYYThh:mm:ss.mmmXXX (example: 02/20/1987T12:04:12.000GMT)

• Three-letter time zones: YYYY-MM-DDThh:mm:ss.mmmXXX (example: 2012-03-25T12:04:12.000GMT)

To set the default date format and time zone:

1. Open Settings, then open Date/Time.

2. Choose the date format and time zone you want.

• User Menu and Settings
• Importing Data into Salesforce
• Export Data from Salesforce

j

Getting Started

Advanced Features

Install Canvas App for Dataloader from MuleSoft

Import Notes into Salesforce

User Menu and Settings

Configure Email Notifications

Managing Cloud Storage Connections

Managing Salesforce Connections

Manage User Access to Dataloader from MuleSoft

Schedule Tasks

Use Import Lookups

Connecting to Box

Connecting to Dropbox

Connecting to FTP

Connecting to SFTP

Working with Attachments

Use Supported Date Formats

Dataloader from MuleSoft FAQ