-
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
Enhance Customer Engagement in Trading in 2024
Introduction: In the fast-paced world of trading, where every second counts, establishing and maintaining strong customer relationships is paramount. Salesforce, a leading customer relationship management…
How to implement Salesforce Communities
Salesforce Communities is now considered as an important requirement that helps businesses to establish a connection with their customers, partners as well as employees. Specific…
How to Transfer Outlook Contacts to Salesforce?
Introduction: Exporting Outlook contacts to Salesforce is a strategic step that enhances customer relationship management and optimizes business processes. Migrating these contacts ensures seamless integration…
Popular Salesforce Videos
Salesforce Introduced Next Generation Of Tableau Cloud
Salesforce added a new member to its fleet of the cloud for customers: Salesforce Tableau Cloud. The Tableau Cloud developed will empower the customers to…
How to Switch your Career from Being an HR or a Recruiter to a Salesforce Developer/QA or a BA
In this video, Shrey has answered one of the most frequently asked questions about how someone who is working in HR or as a Recruiter…
Duplicate Management In Salesforce | Duplicate Rule and Matching Rule
Learn how to work with duplicate rules and duplicate records in Salesforce. This video will cover the following points - 1. Matching Rule (1:20) Get…
