How can I get date format salesforce data loader?

Question

I have a custom date/Time field in salesforce for an object and I am trying to insert values for that field through the data loader.I have used yyyy:mm:dd hh:mm:ss date format in excel. User time zone and company default time zones are same.But when i insert data to that field it's showing date as data as given date -1 day.This is the sample data

But in salesforce it is stored

and

What should I do to store the exact date from excel?

Claudine Tippins · Accepted Answer

For date format salesforce data loader, remember two things about loading date types: Data loader ignores the HH:MM:SS portion of Date types, so you can just write it as YYYY-MM-DD. Reserve the HH:MM:SS for Datetime types. Data loader interprets all dates as GMT. When you look at it in the UI, you are looking at the local time which is MT(GMT-6). Date '2016-01-18' in the CSV, after the load it becomes '01/17/2016 18:00:00' in the UI.

How can I get date format salesforce data loader?

About this question

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Salesforce Tutorials

Salesforce Interview Q&A

Latest Salesforce Blogs

Want answers to more Salesforce questions?

Stay in the loop — it’s free

You’re on the list!