Issue in date cell of excel

[Anonymous]

My formula is not getting calculated in my excel output due to cell format issue. Please see the attached, Talend is generating the output in excel in which the date cell is having the format as "GENERAL" whereas if i changed the format to "Custom" (see the attached) then its working fine. 

Please suggest how to populate the result in excel with this ("Custom") format.

[Anonymous · Accepted solution]

Hello,

Could you please have a look at custom components- tFileExcel components provided by Jan Lolling's to see if it is what you are looking for?

Best regards

Sabrina

[Anonymous]

Its resolved already. Thanks Sab

[Anonymous]

Hello,

Would you mind sharing your solution on forum?

Thanks for your time.

Best regards

Sabrina

[Anonymous]

I added 2 tMap's

Input-->tMap-->tMap-->OutputExcel

In first tMap, i changed the Date format from "YYYY-MM-DD" to "MM-DD-YYYY"

In second tMap, i changed the datatype from "Date" to "String" and it worked.

When i changed the Date format and the Datatype in 1st tMap alone, then i was getting error saying "Cant convert Date to String"

[Anonymous]

Hello,

Here is a built-in method in talend.

TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("dd/MM/yyyy")).

It will analyses the string as a date and then format the result in new one.

Best regards

Sabrina