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:


Written by 

I am Sakthivel Madesh, a certified Salesforce Advanced Developer & Administrator working on Salesforce Technology since 2011. I am currently working in Techforce Services as Sr. Salesforce Developer. I have worked on multiple technologies Like PHP, Java, Salesforce, I am very passionate about Salesforce and to earn 15x Salesforce Certification. I love Trailhead for learning Salesforce Skill and Become a Trailhead 5x Ranger too. I Love to Learn & Share my Salesforce knowledge to Salesforce Learners/Beginner using My Blog and Salesforce Community.

Leave a Reply

Your email address will not be published. Required fields are marked *