topic Read Date in String format in Talend Studio

Read Date in String format

EnriqueLDE — Thu, 25 Mar 2021 16:16:46 GMT

Hi,

My job reads info from an Excel file where there's a date field (01/01/2021). When i define the input metadata i set "String" format to read this field. However, when i check my output i get this date: 01/01/21

Basically i want my output to return 01/01/2021 in string format. Can you explain me how can i get this?

Thank you!

Regards,

Enrique

Re: Read Date in String format

Banupriya — Tue, 30 Mar 2021 11:46:29 GMT

You can convert date to String using talenddate.formatdate( yyyy-mm-dd talenddate.getcurrentdate())

Re: Read Date in String format

gjeremy1617088143 — Tue, 30 Mar 2021 12:12:31 GMT

hi, don't forget coma separator in the method formatdate and quote on the first arg :

TalendDate.formatDate("yyyy-MM-dd",TalendDate.getCurrentDate())

Re: Read Date in String format

gjeremy1617088143 — Tue, 30 Mar 2021 12:14:43 GMT

you can replace TalendDate.getCurrentDate() by the input row of your Excel date field.