-
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
Your Complete Guide to Salesforce Marketing Cloud
Imagine being able to skyrocket your marketing efforts without having to put in extra work and empower your marketing team to create more effective campaigns…
Running Case Assignment Rules From Salesforce Apex
Hi All, We all know that the Case Assignment Rule decides how cases are assigned to users or put into queues. We can create multiple…
Building a Custom Community Leaderboard for an Antivirus Software Company – A Salesforce Success Story
Gamification has become critical for running successful online communities. By implementing gamification techniques, online communities can become more active, and garner more user engagement. Regardless…
Popular Salesforce Videos
Salesforce Education Cloud Consultant: Interview Questions
Salesforce org Education Cloud is the complete customer relationship management software for colleges and universities, helping you track all of your constituent relationships, from prospects…
Introduction to Lightning Web Components: A Practical Example
In this session, Alba Rivas will show how to build a page step-by-step in Lightning Web Components. You will learn some of the basics of…
SQL Row_Number - Salesforce Marketing Cloud Functions in 5 minutes
Cameron Robert shows how to use the Row Number (Over Partition By) SQL function in Salesforce Marketing Cloud. The SQL Row Number function can be…
