Date format

[shalinim1]

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]

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]

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

Once I widen cell it is showing the date.

[vikramk · Accepted solution]

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]

Thank you @Vikram Kumar​ 😊