The cell format is not Date in ( Row. 1 and ColumnNum. 3 )

[Anonymous]

I am getting below error.. after writing data to excel file...........PFA

The cell format is not Date in ( Row. 1 and ColumnNum. 3 )

[fdenis]

your error is not typical it did ^not look like Usual Talend Error.
So witch component is generating this Error?
deactivate / activate subjobs and components to found the source of error.

[TRF]

I strongly recomend to use String datatype for all fields as soon as you expect to push data to salesforce.

[Anonymous]

Hi,

I am trying to put data into excel sheet from salesforce...during that time i am getting this error...could you please tell how to resolve this

this is the format i have in Date .... "yyyy-MM-dd'T'HH:mm:ss'.000Z'" .....PFA

tal3.JPG

[fdenis]

you can try to remove Z (UTC)
check your Windows default dateTime Format
is it the same?
you can also format the date defore inserting into excel

[fdenis]

did you fill an existing excel file?
or is it a new one?

[Anonymous]

I am trying to add new sheet for existing file....

Could you please tell how to parse before inserting into excel..

My windows timezone also(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
 

[fdenis]

add tmap and use format function to convert Date to String

[Anonymous]

Can u please give the syntax to achieve this..

[fdenis]

TalendDate.formatDate("yyyy-MM-dd hh:mm:ss".row1.date)
use the default date format of your computer.