topic Re: Date format in Talend Studio

Date format

shalinim1 — Sat, 16 Nov 2024 01:15:22 GMT

Hi,

I have used the below to load the current date in a csv file.

row1.date=(TalendDate.formatDate("yyyy-MM-dd",TalendDate.getCurrentDate()));

In schema the date column datatype is string.

It is loading in csv file as #########

I want to load the date in the format "yyyy-mm-dd"

vikramk — Fri, 23 Oct 2020 03:28:26 GMT

Could you please widen cell width in excel and take the complete ss of excel and point your cursor and row 2 while capturing ss.

shalinim1 — Fri, 23 Oct 2020 04:34:19 GMT

@Vikram Kumar Before widening the cell it is showing ######

Once I widen cell it is showing the date.

vikramk — Fri, 23 Oct 2020 05:52:26 GMT

Hi @Shalini M ,

If the content of the particular cell is large by default excel shows it as ###, to view the complete information you have to widen the cell.

You are getting your desired output, there is no problem with your output in this case.

Please mark it as solution, if it helped you

shalinim1 — Fri, 23 Oct 2020 07:40:30 GMT

Thank you @Vikram Kumar 😊