[SalesForce] Formating Date time field in excell to import via data loader

I have a custom date/Time field in salesforce for a object and i am trying insert values for that field through the data loader.I have used yyyy:mm:dd hh:mm:ss date format in excell. 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 enter image description here

But in salesforce it is stored as enter image description here and enter image description here

What should i do to store the exact date from excell?

enter image description here

Best Answer

You want to format it as:

yyyy-mm-ddThh:mm:ssZ

Where you can just make hh:mm:ss be 00:00:00.

e.g. 2016-01-18T00:00:00Z

Related Topic