Talend parse date to SalesForce

rabiiii3 — Wed, 29 Jul 2020 11:03:16 GMT

i want to parse a string date in salesforce, but i had this error message :

**Exception in component tMap_1 (LSH_SM_UpsertResidenceHistory_V2_Copy9_Copy1_Copy_Copy_Copy_Copy2) java.lang.RuntimeException: java.text.ParseException: Unparseable date: "Sun Jan 09 00:00:00 CET 29" at routines.TalendDate.parseDate(TalendDate.java:942) at routines.TalendDate.parseDate(TalendDate.java:886)

BTW, in the tmap i'm using this code to convert the date to salesforce format :

TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss'.000+0000'",row4.SalingAgreementDate__c)

i really don't know what is the problem here ! HELP !!

Re: Talend parse date to SalesForce

manodwhb — Wed, 29 Jul 2020 14:45:01 GMT

@Med Rabii Charni , your sting date format is not yyyy-MM-dd'T'HH:mm:ss'.000+0000,which something like EEE MMM dd HH:mm:ss zzz yyyy and first try to understand the input date format for the sting field and the in tmap you convert TalendDate.parseDate("EEE MMM dd HH:mm:ss zzz yyyy ",row4.SalingAgreementDate__c) ad in the output section you change the date format to "yyyy-MM-dd'T'HH:mm:ss'.000+0000'" .

topic Re: Talend parse date to SalesForce in Talend Studio

Talend parse date to SalesForce

Re: Talend parse date to SalesForce