How can I get date format salesforce data loader?
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?
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.