-
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
Salesforce Data Cleansing - Maintain Your Data Quality
In the Salesforce world, the major part is played by data as we all are aware that Salesforce manages to have data in immense amounts…
How to Access Ideas Component in Your Lightning Salesforce Org
The ‘Ideas’ component in Salesforce Community Cloud allows your customers, partners, and employees to directly share and post their ideas on your online community. Enabling the Ideas component allows…
5 Reasons to Embrace Salesforce Managed Service
The managed service model has proven to be highly effective for businesses over the years. With no necessity to set up office infrastructure or hire…
Popular Salesforce Videos
Why Salesforce India is Primed for Growth
Amarendra Kumar, RVP of Alliances and Channels for India at Salesforce, says the region is poised for tremendous growth and opportunity over the next few…
Salesforce Grid Component Modernization with Webix Widgets
Take a break and watch a short video about how we modernized the Salesforce Grid component with Webix.
How to Get Experience as a Fresher in Salesforce World? | The Shrey Sharma Show
Want to start your career in the Salesforce industry? Watch this video by Shrey and learn how you can get experience as a Fresher in…
