tfilterrow create and/or criteria that includes current date plus 30 days

[Anonymous]

I am trying to create using advanced mode criteria where status equals active or status equals inactive and the closing date is less than or equal to today plus 30 days. this is what I have but it's not working....suggestions?

(

(input_row.status.equals("active"))

||

(((input_row.status.equals("inactive")) && (input_row.closing_dt<=TalendDate.ADD_TO_DATE(TalendDate.getCurrentDate(), "DD", 30)))

)

Error says 'insert ")" to complete ArgumentList

[Anonymous · Accepted solution]

It's clear now, try this expression and let me know if it works.

(input_row.status.equals("active"))||((input_row.status.equals("inactive")&&(TalendDate.compareDate(input_row.closing_dt,TalendDate.addDate(TalendDate.getCurrentDate(), -30, "dd"))>=0)))

[Anonymous]

It looks like this worked, I don't have any inactive that are within the last 30 days however it's not bringing in any inactive records , Thanks!

[Anonymous]

Great, thanks for your feedback!