Checking date range

Seven Stars

Checking date range

I have data like this in table

empno,start time,endtime
1,2015-07-01,2015-12-31

and I have to check some xyz date if that falls between above start time and endtime then I should get empno.

how can I achieve above scenario in Tmap.
Tags (1)
Employee

Re: Checking date range

@prasan

 

     I have added the details of solution in the below link.

 

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

 

     Could you please mark the topic as resolved since the resolution has been provided? Kudos are also welcome :-)

 

Warm Regards,

 

Nikhil Thampi


Warm Regards,
Nikhil Thampi
Please appreciate our members by giving Kudos for spending their time for your query. If your query is answered, please mark the topic as resolved :-)

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.