-
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
Top 6 Qualities of Salesforce Consulting Partners to Look Out For in 2024
When it comes to CRM, anywhere we go in India or across the globe, everywhere we see Salesforce and Salesforce consulting partners We all know what Salesforce…
Service from Home: How Industry Leaders are Restructuring Service Operations | Salesforce
As we continue to push through the pandemic and continue to help companies move to a remote working environment, we will also continue publishing regarding…
Salesforce Commerce Cloud Explained: Pricing, Hosting, Performance, Scalability
Nasdaq forecasts that 95% of purchases will be made online by 2040. Statistics also say that the global e-commerce market is expected to reach $18.89 trillion by 2027, compared to $5…
Popular Salesforce Videos
How to import data from Sage ERP to Salesforce - Part 1
Greytrix offers GUMU™ integration for Salesforce with Sage ERP systems - a best-of-breed solution for organizations to enhance their customer interaction. With Salesforce and Sage…
Real-time Scenario: Custom Rollup Summaries Using Triggers | Salesforce Tutorial
Watch this video to learn all about Custom Rollup Summaries Using Triggers using the real-time scenarios. If you have any doubts or concerns do let…
How to use Cauzali in Salesforce Service/sales cloud and all of Salesforce industry clouds. Add functionality to your users with Cauzali
With a maximum price of $6.000 a year for your org. You and your colleague can make all the solutions you want including Community solutions.…
