-
Date field value uploaded using Data Loader is sometimes one day before the date in the file in Salesforce?
When loading data into date fields such as Opportunity Close Date using the Data Loader, the date displayed is sometimes one day before the date in the file. What is the reason and solution in Salesforce?
-
1 Reply
-
The reason for this is that fields such as Close Date are actually date/time fields. When a date is loaded without specifying the time, the time is defaulted to 00:00 – midnight. When another user is in a time zone which is behind the current user’s time zone, the date will show on the previous day. For example:
20 August 2008 00:00 in Paris is 19 August 2008 23:00 in London
Similar issues can arise when daylight savings time begins or ends.
Two simple solutions to this are:
1) Specify a time as well as a date when loading dates using the Data Loader.
or
2) Switch your PC’s time zone to Hawaiian time before starting up the Data Loader.
Log In to reply.
Popular Salesforce Blogs
Integration of Salesforce with Google Calendar using APEX
Salesforce Integration with Google Calendar REST API can also be done by using Apex Code. The following steps show how to integrate Salesforce with Google…
AI, Sustainability, and Innovation: Highlights from Dreamforce 2023
Dreamforce 2023 Key Takeaways Dreamforce 2023 was the largest and most successful Dreamforce yet, with over 180,000 attendees from all over the world. The conference…
Power Play: Mastering Salesforce Integration Patterns And Practices
Ready to turbocharge your Salesforce experience? In our hyper-connected global village, just owning Salesforce isn't enough. You need seamless integration with data, systems, and processes…
Popular Salesforce Videos
Top 5 Features Salesforce Winter Release '21
Even though we're in the middle of one of the strangest summers in our lives, we can rely on one constant: releases from Salesforce. It's…
How to Create Custom Field in Lighting Experience | Salesforce
Fields you create on standard or custom objects are called custom fields. You can create a custom field on the Contact object to store your…
Why There Are So Many Acquisitions in The Salesforce Ecosystem?
Global technology acquisition deals amounted to $634.1 billion in 2020, an increase of 91.8% year-on-year. An acquisition is when one company purchases most or all…
