topic Re: Date in string with compare value in Tmap in Talend Studio

Date in string with compare value in Tmap

Anonymous — Sat, 16 Nov 2024 14:18:58 GMT

Hello,
I'm looking for an example for use a date in iso format ("yyyy-mm-dd") in String type where
i can compare (Date > "2007-12-31") in an expression output. Could you help me please.

Re: Date in string with compare value in Tmap

Anonymous — Tue, 01 Jul 2008 13:41:32 GMT

Hello,
See image.

JC

Re: Date in string with compare value in Tmap

Anonymous — Tue, 01 Jul 2008 15:55:22 GMT

Thank you very mutch JC. I was just trying the compareTo method but i've tried this : I considere Var1 is in date type:
Var.Var1.compareTo(20071231) > 0
But i get this message : "Error compareTo(date) => The method compareTo(date) in the type date is not applicable for the arguments (int)

Re: Date in string with compare value in Tmap

Anonymous — Tue, 01 Jul 2008 16:11:39 GMT

Like I did, you must create a date type variable with the date you want compare to.
The expression for the variable is :
TalendDate.parseDate("yyyy-MM-dd","2007-12-31")

Re: Date in string with compare value in Tmap

Anonymous — Tue, 01 Jul 2008 16:13:11 GMT

It's because compareTo need a date type as parameter and you give a integer. Thats why, on the image, you see the parse Date function.

Re: Date in string with compare value in Tmap

Anonymous — Tue, 01 Jul 2008 16:24:28 GMT

Ok i understand. I did what you purpose and the result is perfect. Thank you

Re: Date in string with compare value in Tmap

_AnonymousUser — Sun, 01 Feb 2015 12:14:28 GMT

Hello,
Thanks for posting this.It helped me.

Re: Date in string with compare value in Tmap

Anonymous — Wed, 08 Apr 2015 13:13:55 GMT

I need to fill a time dimension table so i create this job in the tfilterRow component i would to generate the date < to 2002-12-31 , when i execute this job i have this error: the compareTo (Date) Date type does not apply to the arguments (int)
please help me