-
Why do date fields import incorrectly when I use the Data Loader in salesforce?
Why do date fields import incorrectly when I use the Data Loader in salesforce?
-
1 Reply
-
Hi Saurabh,
When importing date fields using the Data Loader, sometimes dates import incorrectly because the Data Loader converts the date specified in the imported .csv file to GMT. If your machine’s time zone isn’t GMT or if your machine’s clock adjusts for daylight savings time (DST), your dates may be off by a day.
To prevent the Data Loader from adjusting the date when it converts to GMT, directly change the format of cells containing dates to reflect the native time zone.
Open your .csv file in Microsoft® Excel®.
In each cell in which you entered dates, add hour data to represent the native time zone. For example, if the date is June 9, 2011 and the time zone is GMT+8, enter June 9, 2011 8:00. Excel will reformat this to 6/9/2011 8:00.
Right-click the cell in which you entered dates, and click Format Cells.
Click Number | Custom.
In Type, enter yyyy-mm-ddThh:mm:ss.sssZ. For example, if the cell was 6/9/2011 8:00, it’s now 2011–06–09T08:00:00.00Z.
Log In to reply.
Popular Salesforce Blogs
Boost Your Sales with Effective Email Pitch Strategies in Salesforce
Clear communication with prospects is the key to building relationships and increasing sales, especially for B2B businesses. As B2B sales involve higher transaction value and…
Best Books to Prepare for Salesforce Certification
Salesforce is a cloud-based platform that allows you to create and manage cloud-based apps with high flexibility. This platform is primarily intended for businesses and enterprises,…
Fascinatingly fast turnover in Salesforce
While in the previous article we were talking about a very interesting and fun challenge - however one looks at it, it is a challenge…
Popular Salesforce Videos
The Salesforce Team is Talking About What Working for Salesforce is Like
The Salesforce team is talking about what working for Salesforce is like. Watch this video learn about their experience.
Meet us at Dreamforce23 - Unleash the Ultimate Business Experience!
Dreamforce 2023 at San Francisco. Save the dates of September 12–14, 2023, and prepare for an unforgettable experience at Dreamforce 2023. Reserve your position by…
Salesforce Data Loader Tutorial
The Salesforce Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can…
