Please explain this error on event ? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Nidhi ShuklaNidhi Shukla 

Please explain this error on event ?

I am trying to update old records on event and get this error ?
how can I fix it ?

User-added image
Hybin JosephHybin Joseph
Hi Nidhi,

What field are u trying to update is it a date field or date/time also are u using the data loader to update if yes can u check the box in setting s for the data loader which says use European date format and see if that resolves the issue
 
nitish mishranitish mishra
Hi Nidhi, 

Please go through the below link. It has list of accetable format.
https://help.salesforce.com/articleView?id=Data-Loader-Import-data-for-Date-or-Date-Time-field-1327108684799&language=en_US&type=1

Also could you please check the below checkbox that should resolve your issue.

User-added image

Thanks,
Nitish
Nidhi ShuklaNidhi Shukla
my field is date/time
and locale English united state
Nidhi ShuklaNidhi Shukla
and this is my company's setting  (GMT-07:00) Pacific Daylight Time (America/Los_Angeles)
Pritam ShekhawatPritam Shekhawat
Hybin JosephHybin Joseph
If ur locale is US it shud work with MM/DD/YYYY HH:MM:SS
Jeff MayJeff May
You have to format the DateTime specifically in the format supported by Dataloader.  see @Hybin Joseph's post for one of the formats.
Anonymous GaAnonymous Ga

Your data is in the format MM/DD/YYYY 13:30. The field in Salesforce is DATE only, not DATE - TIME. Therefore, remove Times from your Excel sheet. 

Tip: Use the Format YYYY-MM-DD for dates as it an internationally recognised format and so will not return errors!!