topic Re: Compare one date with another specific date in Tmap in Talend Studio

Compare one date with another specific date in Tmap

Anonymous — Fri, 01 Jun 2018 16:39:43 GMT

Hi,

I need to compare one date with 5/1/2018 so I create two local variables and then use compareDate but it doesn't work - V2 can not be resolved as a variable.

Please advise me. Thank you!

V1: TalendDate.parseDate("MM/dd/yyyy",row1.ETD)

V2: TalendDate.parseDate("MM/dd/yyyy","05-01-2018")

Output: V1.compareDate(V2)>=0

Re: Compare one date with another specific date in Tmap

TRF — Fri, 01 Jun 2018 16:47:20 GMT

Have a look to document for TalendDate routines.

https://help.talend.com/reader/_Qg2guINsDl6hsiB7uKWzQ/FbEV9SOAKgdqROp7dcKOQw

Re: Compare one date with another specific date in Tmap

vboppudi — Fri, 01 Jun 2018 17:29:50 GMT

If you created variables in tMap then you have to refer variable with prefix Var.V1 or Var.V2.

Var.V1.compareDate(Var.V2)>=0

Regards,

Re: Compare one date with another specific date in Tmap

Anonymous — Fri, 01 Jun 2018 19:40:11 GMT

Hi,

Thanks for your advise.

After I added Var. I still got error which showed "The method compareDate(Date) is undefined for the type date". I checked I changed data type to "Date" for variables

Re: Compare one date with another specific date in Tmap

vboppudi — Fri, 01 Jun 2018 19:41:22 GMT

is it possible to provide screen shot of job and tMap configuration?

Regards,

Re: Compare one date with another specific date in Tmap

Anonymous — Fri, 01 Jun 2018 19:45:32 GMT

Please see above

Re: Compare one date with another specific date in Tmap

vboppudi — Fri, 01 Jun 2018 20:03:48 GMT

try this TalendDate.compareDate(Var.ETDate,Var.D0501)>=0

Regards,

Re: Compare one date with another specific date in Tmap

Anonymous — Fri, 01 Jun 2018 21:34:22 GMT

After I run with "TalendDate.compareDate(Var.ETDate,Var.D0501)>=0" I got below error info -

Re: Compare one date with another specific date in Tmap

TRF — Fri, 01 Jun 2018 23:20:39 GMT

Check this conversation https://community.talend.com/t5/Design-and-Development/Date-in-string-with-compare-value-in-Tmap/td-p/79371