+ 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.....