Loading

Salesforce Date Field Displays the Previous Day After a Data Loader Import

Publiseringsdato: Oct 12, 2026
Beskrivelse

This is a common issue for organizations with users in multiple time zones, particularly around daylight saving time transitions.

When you load data into date fields, such as Opportunity Close Date, using Salesforce Data Loader, the date displayed in the application is sometimes one day earlier than the date in the file.

The reason is that fields such as Close Date are actually date/time fields. When a date is loaded without specifying the time, the time defaults to 00:00 (midnight). When another user is in a time zone that is behind the current user's time zone, the date shows as 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 saving time begins or ends.

Løsning

This article explains how to resolve a Salesforce date field that displays the previous day's date after you import or update records with Data Loader.

How to Check Whether a Salesforce Field Is a Date or a Date/Time Field

To resolve this issue, check the Data Type of the field by reviewing it in Setup for your organization. This lets you see whether it is a Date field or a Date/Time field.

How to Format Date and Date/Time Values in a CSV File for Data Loader

For more information on how to format a Date/Time field, review Format the 'Date' and 'Date Time' data in a CSV file For Salesforce Data Loader.

Knowledge-artikkelnummer

000385444

 
Laster
Salesforce Help | Article