Compare one date with another specific date in Tmap

[Anonymous]

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

[TRF]

Have a look to document for TalendDate routines.

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

[vboppudi]

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,

[Anonymous]

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

[vboppudi]

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

Regards,

[Anonymous]

Please see above

[vboppudi]

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

Regards,

[Anonymous]

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

[TRF]

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