This post is a part of the daily blog series
A Tip A Day, daily dosage of learning!
Day #14 – Data Load Date / DateTime Fields into Salesforce
While data loading any Date fields into Salesforce, remember to include the TIMEZONE as well in your csv file. If you miss the time zone, it will subtract 1 day from the date you want to load.
Example: If you put 25/02/2017 as your date in your csv file, then if will load as 24/02/2017 (1 day behind).
Solution: To load the date correctly, you need to change the format of the column in CSV to YYYY-MM-DDThh:mm:ssZ.
And lets say if you are on GMT+8, then you need to change the value of the fields to include the 08 hr also by changing the value as shown below.
Read all other tips of the blog series here – A Tip A Day, daily dosage of learning!
sfdcFanBoy 
One Reply to “A Tip A Day #14 – Data Load Date and DateTime Fields”