topic Re: Data between two dates in Expression builder in Talend Studio

Data between two dates in Expression builder

joe86 — Mon, 03 Dec 2018 05:06:10 GMT

Hi All,

I need to fetch only records between two dates. Also i need this to be written in the tMap expression builder.

I have an incoming DATE which has past and future dates. But i need to fetch only the dates that are between CurrentDay and CurrentDay+7 and rest all the dates should be ignored in my output. This has to be done in tMap expression builder.

Can someone please help on this?

Is it possible to bring in BETWEEN like function or DateDiff in Talend??

Re: Data between two dates in Expression builder

Anonymous — Mon, 03 Dec 2018 05:11:56 GMT

@joe86

I have done a similar exercise in one of my earlier posts. Could you please refer my comment in the below post (6th comment), which is having code and screenshots? I hope it will satisfy your query.

https://community.talend.com/t5/Design-and-Development/Scenario-based-Question-in-Talend/m-p/140691#M86957

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Data between two dates in Expression builder

joe86 — Mon, 03 Dec 2018 05:32:39 GMT

@nthampi
This worked. Thanks a lot. below is the one...
TalendDate.compareDate(TalendDate.getCurrentDate(),row12.myDate)<=0 && TalendDate.compareDate(row12.myDate,TalendDate.addDate(TalendDate.getCurrentDate(),7,"dd"))<=0

When i use multiple columns using OR condition, in Expression builder, it does not work.

(TalendDate.compareDate(TalendDate.getCurrentDate(),row12.myDate1)<=0 && TalendDate.compareDate(row12.myDate1,TalendDate.addDate(TalendDate.getCurrentDate(),7,"dd"))<=0) ||
(TalendDate.compareDate(TalendDate.getCurrentDate(),row12.myDate2)<=0 && TalendDate.compareDate(row12.myDate2,TalendDate.addDate(TalendDate.getCurrentDate(),7,"dd"))<=0) ||
(TalendDate.compareDate(TalendDate.getCurrentDate(),row12.myDate3)<=0 && TalendDate.compareDate(row12.myDate3,TalendDate.addDate(TalendDate.getCurrentDate(),7,"dd"))<=0)

What i want to achieve is, if date1 is not between currentDay+7, then i have to check the same for date2 with same conditon and same for date3. what am i doing wrong here?? can u please help??

Re: Data between two dates in Expression builder

Anonymous — Mon, 03 Dec 2018 05:44:23 GMT

@joe86

Are you getting any error? I believe you will have to verify the data of each expression separately before merging them. An easy way is to print the output of each expression to a tlogrow and verify. I am sure you can crack it with some quick analysis 🙂

Warm Regards,

Nikhil Thampi

Re: Data between two dates in Expression builder

joe86 — Mon, 03 Dec 2018 05:52:57 GMT

@nthampi
I did not get any error as such, but this filter is not making any effect in my output. but when i use individually (one filter at a time), i am getting the desired output.

Re: Data between two dates in Expression builder

Anonymous — Mon, 03 Dec 2018 06:16:09 GMT

Hi,

Could you please print the expression results as tmap columns and share the details here? Also add one additional column which will give the results after merging. Lets quickly check whether its processing boolean correctly. Please note that they are boolean fields and you are using an OR condition.

Warm Regards,

Nikhil Thampi

Re: Data between two dates in Expression builder

joe86 — Mon, 03 Dec 2018 06:29:16 GMT

hey,
i am sorry, the filter is working for me. I am getting the desired output. previously, i was not getting as required. anyways, let me check for more data and see..
thanks again

Re: Data between two dates in Expression builder

Anonymous — Mon, 03 Dec 2018 06:33:41 GMT

@joe86

Yes. I would suggest to verify the data for all different conditions. Anyway, now you know how to do comparison and its just a matter of doing condition checking based on multiple boolean values. You can crack it 🙂

Warm Regards,

Nikhil Thampi