Trouble concatenate a String + Date + Date

[Anonymous]

Hello,
I am trying to concatenate 3 input fields together. One is a string field and the other two are date fields.
My Input fields are as follows:
Selic Code = 100000
Issue Date = 20060804
Maturity Date = 20080401
Below is my expression in tMap:
("YMF")+("=")+(row2.Selic_Code)+("_")+(row2.Issue_Date)+("_")+(row2.Maturity_Date)+("=")
The Output Talend gives me is:
YMF=100000_Fri Aug 04 00:00:00 CDT 2006_Tue Apr 01 00:00:00 CDT 2008=
The Output I want to get is:
YMF=100000_20060804_20080401=
Can anyone help me correct this expression?
Thanks in advance,
David

[Anonymous]

what is the format of your fields Issue Date & Maturity Date? String or date?

[Anonymous]

Date, both have a Date Pattern of "yyyyMMdd"

[Anonymous]

try this in your tMap:
("YMF")+("=")+(row2.Selic_Code)+("_")+(TalendDate.formatDate("yyyyMMdd",row2.Issue_Date))+("_")+(TalendDate.formatDate("yyyyMMdd",row2.Maturity_Date))+("=")

[Anonymous]

Yes that worked, Thanks!

[Anonymous]

you'll welcome