https://community.qlik.com/t5/Talend-Studio/Checking-date-range/m-p/2252350#M36007 I have data like this in table<BR /><BR />empno,start time,endtime<BR />1,2015-07-01,2015-12-31<BR /><BR />and I have to check some xyz date if that falls between above start time and endtime then I should get empno.<BR /><BR />how can I achieve above scenario in Tmap.<BR /> Thu, 15 Nov 2018 17:32:05 GMT Prasanna3 2018-11-15T17:32:05Z https://community.qlik.com/t5/Talend-Studio/Checking-date-range/m-p/2252350#M36007 I have data like this in table<BR /><BR />empno,start time,endtime<BR />1,2015-07-01,2015-12-31<BR /><BR />and I have to check some xyz date if that falls between above start time and endtime then I should get empno.<BR /><BR />how can I achieve above scenario in Tmap.<BR /> Thu, 15 Nov 2018 17:32:05 GMT https://community.qlik.com/t5/Talend-Studio/Checking-date-range/m-p/2252350#M36007 Prasanna3 2018-11-15T17:32:05Z https://community.qlik.com/t5/Talend-Studio/Checking-date-range/m-p/2252351#M36008 <P><A href="https://community.qlik.com/s/profile/0053p000007LOiPAAW">@prasan</A></P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp;I have added the details of solution in the below link.</P> <P>&nbsp;</P> <P><A href="https://community.qlik.com/s/feed/0D53p00007vCkeMCAS#M86957" target="_blank">https://community.talend.com/t5/Design-and-Development/Scenario-based-Question-in-Talend/m-p/140691#M86957</A></P> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp;Could you please mark the topic as resolved since the resolution has been provided? Kudos are also welcome <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>&nbsp;</P> <P>Warm Regards,</P> <P>&nbsp;</P> <P>Nikhil Thampi</P> Fri, 16 Nov 2018 07:06:30 GMT https://community.qlik.com/t5/Talend-Studio/Checking-date-range/m-p/2252351#M36008 Anonymous 2018-11-16T07:06:30Z