tmap compare date syntax

[pawe84]

Hi everyone,

I want to compare an invoice date for an agent in tmap and if the date is less then

'01.06.2022' then the field qualified will be zero.

IF AGENT_ID='SMITH' AND INV_DATE =< '01.06.2022'

THEN QUALIFIED=0

ELSE

QUALIFIED

Is this syntax correct?

row1.AGENT_ID.equals('SMITH') && (

TalendDate.compareDate(row1.INV_DATE,TalendDate.parseDate("dd.MM.yyyy", "01.06.2022")) < 0 ? 0 : row1.

QUALIFIED

Thnaks for your advice.

[ThWabi · Accepted solution]

Hello pawe84,

a) You opened a parenthesis after "&&", it needs a matching closing one at the end.

b) Within "equals", the Name SMITH needs to be in double quotation marks (not single ones), because it's a String in Java.

Best regards,

Thomas