login

Tip of the Week

Tip of the Week – Best formatting for importing “Date” and “Date/Time”

Technology is pretty great. After all, if you told a person 50 years ago about all the cool things we would have, eg. smartphones and self-driving cars, they would probably not believe you. However, sometimes simple things don’t always work as smoothly as we would like.

When working in Salesforce, users may have trouble importing changes to the “Date” and “Date Time” Data Type fields when the corresponding values in the CSV file do not have a specific formatting or correspond with the org’s time zone settings. I know right? The CSV isn’t formatted exactly right so the whole process breaks down. Sad face.

However, until the smart machines take away all our jobs and do all the work for us, here is the formatting you need to make sure your imports work.

“Date” field acceptable formats

  • YYYY-MM-DD
  • YYYY-MM-DD hh:mm:ss
  • YYYY-MM-DD hh:mm:ss
  • YYYY-MM-DDThh:mm:ssZ
  • YYYY-MM-DDThh:mm:ss.sssZ

“Date Time” field acceptable formats

  • YYYY-MM-DD hh:mm:ss
  • YYYY-MM-DDThh:mm:ssZ
  • YYYY-MM-DDThh:mm:ss.sssZ

Continued reading on Date Formats and Date Literals

 

-Ryan and the Salesforce Guys

, , , , , ,

No comments yet.

Leave a Reply