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
swaranswaran 

Date Error:

Hi,

I am importing data through DataLoader.I am getting the following error when I load the data.

 

Subscription Start Date: invalid date: Wed May 15 00:00:00 GMT 9

 

Subscription Start Date is Date type field.

 

How to over come this?

 

Thanks.

Best Answer chosen by Admin (Salesforce Developers) 
JimRaeJimRae
my guess is you will need to update the field to include the full 4 digit year.

All Answers

JimRaeJimRae

According to the Dataloader documentation, the date needs to be formated as follows, make sure your source dates are in one of these formats:

 

We recommend you specify dates in the format yyyy-MM-ddTHH:mm:ss.SSS+/-HHmm, where:
• yyyy is the four-digit year
• MM is the two-digit month (01-12)
• dd is the two-digit day (01-31)
• HH is the two-digit hour (00-23)
• mm is the two-digit minute (00-59)
• ss is the two-digit seconds (00-59)
• SSS is the three-digit milliseconds (000-999)
• +/-HHmm is the Zulu (UTC) time zone offset
A compete list of supported date formats follows:
• yyyy-MM-dd'T'HH:mm:ss.SSS'Z'
• yyyy-MM-dd'T'HH:mm:ss.SSS Pacific Standard Time
• yyyy-MM-dd'T'HH:mm:ss.SSSPacific Standard Time
• yyyy-MM-dd'T'HH:mm:ss.SSS PST
• yyyy-MM-dd'T'HH:mm:ss.SSSPST
• yyyy-MM-dd'T'HH:mm:ss.SSS GMT-08:00
• yyyy-MM-dd'T'HH:mm:ss.SSSGMT-08:00
• yyyy-MM-dd'T'HH:mm:ss.SSS -800
• yyyy-MM-dd'T'HH:mm:ss.SSS-800
• yyyy-MM-dd'T'HH:mm:ss
• yyyy-MM-dd HH:mm:ss
• yyyyMMdd'T'HH:mm:ss
• yyyy-MM-dd
• MM/dd/yyyy HH:mm:ss
• MM/dd/yyyy

swaranswaran
 In CSV file I see the Field has in the format of mm/dd/yy.
JimRaeJimRae
my guess is you will need to update the field to include the full 4 digit year.
This was selected as the best answer
swaranswaran
Thank You its working
RupBRupB

My first experience with dates in the Data Loader was that items were loaded in the CA, USA TimeZone, presumably where the salesforce.com data center is. As I am in Europe, my dates were shifted by 1 day (back in time).

 

I did not find a way of adding the timezone on the date without adding the time, so I format dates like this :

e.g. 2008-07-18T18:00:00.000CET, i.e. 18 july 2008 at 6pm CET time.

 

I hope this helps :smileyhappy:

Rup