[resolved] The cell format is not Date in row XXX error

[Anonymous]

Hi,
I have a Date column in my input excel sheet, in the format 16-nov-2011.
In the look up date table i have the date value in mm/dd/yyyy format. In the tmap i need to look up for the date from date table and i am using the following for that:-
TalendDate.formatDate("mm/dd/yyyy", inputSheet.Date)
When i run th job i am getting the following error :-
The cell format is not Date in row XXXX

If i don't specify the input.Date as Date type , it gives a different error which says TalendDate.formatDate() method is not applicable for (String,String) it has to be (String,Date)
Can anyone please help me on this?
Thanks,
Manju

[Anonymous]

Hi, i have a source in excel file with date format like "MM-dd-yyyy"and "dd-MM-yyyy" now i have to get this source into target table . how to get it.
Iam getting the error like the cell format is not in date.........?

[krengan21]

Hi,
I am getting error like this "The cell format is not Date in ( Row. 1 and ColumnNum. 4 )" .Can anybody help me out