topic [resolved] Comparing 2 dates in Talend in Talend Studio

[resolved] Comparing 2 dates in Talend

Anonymous — Mon, 18 Jul 2016 05:57:40 GMT

Hi there,
I am trying to compare 2 dates in tmap but am getting error as
"The operator >= is undefined for the argument type(s) java.util.Date, java.util.Date".
The condition that i am trying to put in is : TIMECREATED >= DATEADD(DAY , -30, CI_START_DT) && TIMECREATED <= CI_START_DT.
I need to fetch out data between start date and 30 days prior to start date. But as I try to use that as an expression, I get the error as stated above.
I have checked & confirmed the datatype of both columns.
Can you please help me.
Regards,
Sunny

Re: [resolved] Comparing 2 dates in Talend

Anonymous — Mon, 18 Jul 2016 09:44:52 GMT

Take a look in Routines.system.TalendDate.

There are Date comparison routines to help you.

Re: [resolved] Comparing 2 dates in Talend

Anonymous — Tue, 19 Jul 2016 00:28:35 GMT

I am not able to find something good in Talenddate.
Can you help me with something relevant.

Re: [resolved] Comparing 2 dates in Talend

Anonymous — Tue, 19 Jul 2016 10:10:59 GMT

They are there.
If your example is SQL syntax, you need to translate it to Java

public static int compareDate(Date date1, Date date2, String pattern)

public static Date addDate(Date date, int nb, String dateType)