-
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
Salesforce Automation Tools - Work Faster And Smarter
Salesforce offers businesses a complete package for streamlining and accelerating their business procedures. Salesforce is well-equipped with a variety of apps known as Salesforce Automation Tools…
What are Salesforce Flows? | All You Need to Know
Salesforce Flows Salesforce Flow, formerly known as Visual Workflow, is a cloud-based automation tool provided by Salesforce. It allows users to create and automate business…
Things to Consider Before Deactivating a Salesforce Trigger
Introduction Triggers are an Apex script that runs before or after data manipulation language(DML), as an example, it invokes when we insert, deletes, update, merge,…
Popular Salesforce Videos
5 Service Cloud Dashboards For Your Board | Webinar
Discover the Power of Service Cloud Dashboards! Watch AblyPro's exciting webinar video on 5 Service Cloud Dashboards For Your Board' to unlock the secrets of…
Salesforce For Beginners - Create Lookup , Master-Detail Relationship and Rollup Summary
Salesforce Administration tutorial which demonstrates how to create Lookup Relationship, Master-Detail Relationship and Rollups . Things to be learned from the video : How to…
What is Record Types in Salesforce?
Record Types is where you have multiple page layouts to a specific profile. Watch this video to learn all about it.
