Talend community forum / [resolved] [URGENT] Impossible to convert from Boolean to Date

ienax_ridens · 2012-03-09 12:56:15

Tags: [boolean, database, date, excel, mssql, xls, xlsx]

My problem is very simple:

from excel file I load a Date as String, in tMap I want to put that value in a Date field and I used the following function:

TalendDate.isDate(rowN.DATE, "ddMMyyyy")

...but when I build the job, I have the error "Impossible to convert Bolean value to a Date value".

--------------

I've tried also many other methods (e.g. load directly Date values from excel, .xls and .xlsx), but I had other problems.
I tried also to format the values as strings in the excel and in the schema of input excel, format date fields as Date, but error also in this case...I don't have ideas any more...

Talend 4.1.1

--------------

Thanks to all

walkerca · 2012-03-09 13:16:01

Hi,

isDate() is returning a boolean, so it can't be used in a date assignment. If you have a date string, try TalendDate.parseDate("ddMMyyyy", rowN.DATE).

Even though it looks like you have a string in an Excel date field, it's actually a number plus a format. This blog post suggests defining the Date field in the Excel input schema: http://bekwam.blogspot.com/2011/03/exce … udio.html.

ienax_ridens · 2012-03-09 14:08:06

walkerca wrote:
Hi,

isDate() is returning a boolean, so it can't be used in a date assignment. If you have a date string, try TalendDate.parseDate("ddMMyyyy", rowN.DATE).

Even though it looks like you have a string in an Excel date field, it's actually a number plus a format. This blog post suggests defining the Date field in the Excel input schema: http://bekwam.blogspot.com/2011/03/exce … udio.html.

Thanks a lot walkerca!
Now I have not the error (even if I have "Null Pointer exeption, but I think it is relative to another thing).

Thank you again

JohnGarrettMartin · 2012-03-09 17:23:48

not a solution, but it seems relevant to this discussion

Uploaded Images

pcoffre · 2012-03-12 11:58:08

Very funny John!

Announcement

Unanswered posts

#1 2012-03-09 12:56:15

[resolved] [URGENT] Impossible to convert from Boolean to Date

#2 2012-03-09 13:16:01

Re: [resolved] [URGENT] Impossible to convert from Boolean to Date

#3 2012-03-09 14:08:06

Re: [resolved] [URGENT] Impossible to convert from Boolean to Date

walkerca wrote:

#4 2012-03-09 17:23:48

Re: [resolved] [URGENT] Impossible to convert from Boolean to Date

#5 2012-03-12 11:58:08

Re: [resolved] [URGENT] Impossible to convert from Boolean to Date

Board footer