Skip to Content

TheBlogReaders.com

Salesforce.com, PHP, MySQL, Javascript, Ajax, Htacces

accepting DateTime/Timestamp format in Salesforce dataloader

Be First!
by October 16, 2013 Data Loader, SALESFORCE

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: http://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

(1880)

Previous
Next

Leave a Reply