topic Re: how to filter data based on dates? in Talend Studio

how to filter data based on dates?

Anonymous — Thu, 13 Jun 2019 08:24:13 GMT

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 ?

Re: how to filter data based on dates?

Anonymous — Thu, 13 Jun 2019 08:49:52 GMT

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.

Re: how to filter data based on dates?

fdenis — Thu, 13 Jun 2019 08:54:05 GMT

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

Re: how to filter data based on dates?

Anonymous — Thu, 13 Jun 2019 10:02:53 GMT

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

Re: how to filter data based on dates?

fdenis — Thu, 13 Jun 2019 12:53:20 GMT

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