A Tip A Day #14 – Data Load Date and DateTime Fields

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.

 

dataload_date_time_sfdcfanboy_salesforce

 

Read all other tips of the blog series here – A Tip A Day, daily dosage of learning!

Advertisements

One Reply to “A Tip A Day #14 – Data Load Date and DateTime Fields”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s