1.7K

Accepting DateTime/Timestamp format in Salesforce dataloader

Date and DateTime Formats:
you need to specify dates in the format yyyy-MM-ddTHH:mm:ss.SSS+/-HHmm:

• yyyy is the four-digit year
• MM is the two-digit month (01-12)
• dd is the two-digit day (01-31)
• HH is the two-digit hour (00-23)
• mm is the two-digit minute (00-59)
• ss is the two-digit seconds (00-59)
• SSS is the three-digit milliseconds (000-999)
• +/-HHmm is the Zulu (UTC) time zone offset

The following date formats are also supported:

• yyyy-MM-dd’T’HH:mm:ss.SSS’Z’
• yyyy-MM-dd’T’HH:mm:ss.SSS Pacific Standard Time
• yyyy-MM-dd’T’HH:mm:ss.SSSPacific Standard Time
• yyyy-MM-dd’T’HH:mm:ss.SSS PST
• yyyy-MM-dd’T’HH:mm:ss.SSSPST
• yyyy-MM-dd’T’HH:mm:ss.SSS GMT-08:00
• yyyy-MM-dd’T’HH:mm:ss.SSSGMT-08:00
• yyyy-MM-dd’T’HH:mm:ss.SSS -800
• yyyy-MM-dd’T’HH:mm:ss.SSS-800
• yyyy-MM-dd’T’HH:mm:ss
• yyyy-MM-dd HH:mm:ss
• yyyyMMdd’T’HH:mm:ss
• yyyy-MM-dd
• MM/dd/yyyy HH:mm:ss
• MM/dd/yyy

For Example: https://theblogreaders.com/how-to-set-datetime-format-in-csv-file-while-importing-data-from-csv-to-salesforce-activity-object/

Source: http://wiki.developerforce.com/page/Data_Loader

http://help.salesforce.com/apex/HTViewHelpDoc?id=supported_data_types.htm