https://community.qlik.com/t5/Talend-Studio/Date-Range/m-p/2268649#M47142 Read the documentation for TalendDate routines to lear how to compare dates. Thu, 22 Nov 2018 18:00:18 GMT TRF 2018-11-22T18:00:18Z https://community.qlik.com/t5/Talend-Studio/Date-Range/m-p/2268648#M47141 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 context start_date if that falls between above start time and endtime then I should get empno this query I have to write in dbcomponent Thu, 22 Nov 2018 17:24:37 GMT https://community.qlik.com/t5/Talend-Studio/Date-Range/m-p/2268648#M47141 Prasanna3 2018-11-22T17:24:37Z https://community.qlik.com/t5/Talend-Studio/Date-Range/m-p/2268649#M47142 Read the documentation for TalendDate routines to lear how to compare dates. Thu, 22 Nov 2018 18:00:18 GMT https://community.qlik.com/t5/Talend-Studio/Date-Range/m-p/2268649#M47142 TRF 2018-11-22T18:00:18Z