function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MichaelWouldMichaelWould 

Invalid date error when attempting to import date/time data from csv to custom object

Hi,

 

I'm attempting to import date/time values into a custom object from csv, using the Setup / Data Management / Import Custom Object wizard from SF.

 

The field in SF is set as a Date/Time field.  The csv field is formated as d/mm/yyyy h:mm

 

However I get an invalid date error when attempting to import - what am I missing here....?

 

Thanks in advance.

 

Michael

IspitaIspita

Hi,

You have to convert the datetime to the following format:-

 

  1999-01-01T23:01:01Z

Then your error should be rectified ...

Also refer to the following link for more on date formats :-

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_calls_soql_select_dateformats.htm

 

Hope this helps.....