Results 1 to 1 of 1
-
03-07-2017, 05:45 PM #1
- Join Date
- Jun 2014
- Posts
- 137
CRM 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
The CloudMyBiz Team
.
Similar Threads
-
CRM Tip of the Week - Manage time off and more in Salesforce with Vaykay
By HenryA in forum PromotionsReplies: 0Last Post: 11-30-2016, 11:47 AM -
Month to date???
By FunderGal in forum Deal BinReplies: 11Last Post: 09-23-2016, 11:41 AM -
CRM Tip of the Week – Back up Salesforce data in in no time at all
By HenryA in forum PromotionsReplies: 0Last Post: 06-16-2015, 11:52 AM -
NEW ISSUE for 3rd TIME THIS WEEK....
By AndyYSCISOdept in forum Merchant Cash AdvanceReplies: 17Last Post: 04-21-2014, 09:29 AM