[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]

You can get that error "the cell format is not date..." when the date in the excel file is the result of a formula.

[Anonymous]

Hi,
The date in the cell is hard coded it is not a result of any formula.
Thanks,
Manju

[Anonymous]

Hi,
When i try this ,
TalendDate.formatDate("mm/dd/yyyy", TalendDate.parseDate("MM/DD/YYYY",row1.Date))
i am getting this error..
java.text.ParseException: Unparseable date: "28-Nov-11"
Can anyone please tell me how to rectify this?
Thanks,
Manju

[Anonymous]

Please find the screen shot of the same attached.
Please guide me on how to rectify this problem.
Thanks,
Manju

[Anonymous]

Hi,
Can anyone please help me on this issue please? Am stuck with this .

Many Thanks in advance,
Manju

[Anonymous]

Hi
Try this expression:
TalendDate.formatDate("MM/dd/yyyy", TalendDate.parseDate("MM/dd/yy",row1.Date))
Best regards
Shong

[Anonymous]

Hi Shong,
when i tried this i got the following error :-
java.lang.RuntimeException: java.text.ParseException: Unparseable date: "28-Nov-11"
I even tried the format dd-Mmm-yy yesterday , even that doesnt seem to work.
Please advise me on how to go about this.
Many Thanks,
Manju

[Anonymous · Accepted solution]

Sorry, the expression should be:
TalendDate.formatDate("MM/dd/yyyy", TalendDate.parseDate("dd-MMM-yy",row1.Date))

[Anonymous]

Thanks Shong , that worked !!!!