function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Swamy P R NSwamy P R N 

what is the date format for inserting into custom object using dataloader

Hi Buddies,

Am uploading Start date field into my custom object using data loader.
Field data type is Date only.
Date formats are :
01/01/14    :    Start Date: invalid date: Sun Dec 31 00:00:00 GMT 13
07/01/14    :    Start Date: invalid date: Sat Jun 30 00:00:00 GMT 14

Time - Zone is : GMT-05:00

How can i fix this issue, all are inserted except this date field.
Can you tell me what is the format i need to give in excel sheet.
HitHit
Hi Swamy,

Select date column in excel and click format. In format select just date ex. 06/19/14. Date with time shouldn`t be selected in your source file format.
That would solved your data loader issue.