Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rabiiii3
Contributor
Contributor
‎2020-07-29 07:03 AM

Talend parse date to SalesForce

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 !!

Labels (4)
Labels
351 Views
0 Likes
1 Reply
manodwhb
Champion II
Champion II
‎2020-07-29 10:45 AM

@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'" .

 

351 Views
0 Likes