compare Date between 2 dates

[Anonymous]

Hello,

I have 2 Tables

Dates.txt:

Date

2019-05-05

2019-05-20

2019-05-30

SecondTable.txt:

Week,StartDate,EndDate

Week1,2019-05-01,2019-05-07

Week2,2019-05-08,2019-05-14

Week3,2019-05-15,2019-05-21

Week4,2019-05-22,2019-05-31

Need Result as :

Date

2019-05-05   Week1

2019-05-20   Week3

2019-05-30   Week4

i have use Comparedate but not working..So please help.

[Anonymous · Accepted solution]

Hi,

    The issue can be resolved by below method. Please refer the screenshots.

The function is as shown below.

TalendDate.compareDate(row2.StartDate,row1.date)<=0 && TalendDate.compareDate(row1.date,row2.EndDate )<=0

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂