-
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
What ‘Sales Cloud Einstein: Forecasting’ has for sales representatives
Many Sales Leaders today rely on outdated systems and incomplete spreadsheets to project sales. Victims of inaccurate forecasts and underperforming businesses, they suffer lost deals…
Reasons To Choose Salesforce CRM for Agribusiness | Salesforce 101
Agribusinesses are increasingly turning to Salesforce CRM (Customer Relationship Management) to help them streamline their operations, connect with customers and increase profits. As the world’s…
Definition and Benefits of Salesforce Marketing Cloud
Salesforce is a leading provider of cloud-based software solutions for sales, marketing, and customer service. Salesforce Marketing Cloud is a comprehensive platform that allows businesses…
Popular Salesforce Videos
How the Salesforce Ecosystem Helped My Career
Welcome back to 100DaysofTrailhead.com! Your involvement in the Salesforce Ecosystem can be a great boost to your career. In this video, Eric talks about the…
Algoworks Is Now A Salesforce Summit (Platinum) Partner | Salesforce Consulting Services
It's been just a year since we became Salesforce gold consulting partners. Algoworks has now been recognized as a Salesforce Summit Partner (also known as…
What are Custom Settings in Salesforce?
Custom settings are similar to custom objects in that they let you customize org data. Unlike custom objects, which have records based on them, custom…
