+ Start a Discussion
dwickdwick 

Apex dataloader dateTime issue

Hi,

When bulk inserting from a csv file my dateTime fields show the correct date, but the time is always 8:00PM for some reason.  Any idea why this is happening?

 

The value in the csv is as follows: 4/2/2010  4:27:00 AM

 

Thanks,


Dave

Ispita_NavatarIspita_Navatar

Is this happening with all your DateTime fields or any specific field?

I suggest you convert the dates into the following format:-

 

2009-014:57:24.000Z

 

I think as salesforce converts the datatime provided to this format in which it is stored in the system in  causes those slips.

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.