The cell format is not Date in

[Anonymous]

Hi,
I'm using the excel source data to load the data into the relational table and I'm getting below error.
Can anyone please help me?
The cell format is not Date in ( Row. 2 and ColumnNum. 6 )

Thanks,

[Anonymous]

Are you trying to insert non-date data from the excel into a date data in the relational table? Maybe you have to format it into a date first.

[Anonymous]

Hi,
I think you have 2 solutions :
- convert your excel column file into date format and import your file
- import your file and conevrt the string date into date (use TalendDate.parseDate("yyyy-MM-dd", row1.yourData))

[Anonymous]

Hi,
Can we consider this topic as resolved ? If yes, can you prefix this title topic with ?
Thanks,
Arnaud