how to filter data based on dates?

[Anonymous]

I want to filter invoice data based on invoice date greater than 1 Jan 18. 

how can i implement this using tfilter?  do i need to use advanced mode ?

[Anonymous · Accepted solution]

Hi Pankaj,

In advanced mode, try this :

input_row.date.after( TalendDate.parseDate("yyyy-MM-dd","2018-01-01"))

What you put in the parseDate depends of the format of your date. Here i'ts an example.

[fdenis]

you may use something like that:
TalendDate.diffDate(Date1(), Date2(), "dd")>0

[Anonymous]

I have some date in which we have invoice date null, So how can I NVL that?

Say if invoice date is null then I want to check invoice_Sent_Date after 1 jan 18

[fdenis]

(yourdate==null)?ifyes:ifnot
it's an inlin if in java. you can use it on tmap