This is a common issue for organizations with users in multiple time zones, particularly around daylight saving time transitions.
When loading data into date fields such as Opportunity Close Date using the Data Loader, the date displayed in the application is sometimes one day earlier than the date in the file.
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.
To resolve this issue, check the Data Type of the field by reviewing it in Setup for your organization. This will allow you to see if it is a Date or a Date/Time field.
For more information on how to format the a Date/Time field, review Format the 'Date' and 'Date Time' data in a CSV file For Salesforce Data Loader
Format the 'Date' and 'Date Time' data in a CSV file For Salesforce Data Loader
Why do date fields import incorrectly when I use the Data Loader?
000385444

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.