One Star

date difference format

hi guys,
i am using this function for date difference,

TalendDate.diffDate(TalendDate.getCurrentDate(), BI01_TREASURY.MATURITY_DT)

i am getting this error,
ERROR: "Typemismatch:cannot convert from long to date"
note:-
BI01_TREASURY.MATURITY_DT
---------------------------
2008-11-03 00:00:00

HOW WE CAN SOLVE?have any idea........

rgds
1 REPLY
Employee

Re: date difference format

Well, then, it's like it says: type mismatch! I guess diffDate returns a long but the target column is typed as a date? Note that the time-span between two dates can hardly be a date too...
This sounds an awful lot like a TOS question though. Would you please post your question in the right forum instead: http://www.talendforge.org/forum/viewforum.php?id=2