date format 1 JAN 2018 To 1-01-2018

[Anonymous]

hello,

Is there any way to convert date 1 Jan 2018 to  {dd-MM-yyyy 01-01-2018 }?? 

or how can we handle it.

[TRF]

Have a look to Talend date routines

[Jesperrekuh]

// when its a String type
TalendDate.parseDate("d MMM yyyy", row1.YourDateAsStringType )
// You first need to convert it
// then when its a Date type
TalendDate.formatDate("dd-MM-yyyy", row1.YourDateAsDateType )

[ankit7359]

Hi,

you can convert date to dd-mm-yyyy, if u refer to the screenshot - Scenario-1.png, i have taken the date what you have mentioned(01 Jan 2018) in the trowgenerator and then in tmap i have converted the date format as to dd-MMM-yyyy and later printing the same onto tlogrow.

For further pls check the Scenario-1-rowgenerator,Scenario-1-tmap.

For further queries... feel free to get back

Thanks

Ankit

Scenario-1-tmap.PNG
Scenario-1-rowgenerator.PNG
Scenario-1.PNG