https://community.qlik.com/t5/QlikView/Filter-data-based-on-date-which-should-lie-between-start-date/m-p/2008274#M1221623 <P>I have one table in which I have start date , end date , part number, part sale date, cost. I want filter data by checking if the partsale date lies between start date and end date.</P> <P>Table:</P> <P>Partnumber.&nbsp; &nbsp; &nbsp;Part cost.&nbsp; &nbsp; &nbsp;Part sale date&nbsp; &nbsp;start date.&nbsp; &nbsp; End date</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.99&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/4/2005.&nbsp; &nbsp; &nbsp;6/17/2006</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.99&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; 6/17/2006.&nbsp; 10/4/2010</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/10/2019.&nbsp; &nbsp; &nbsp;9/18/2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Expected result</P> <P>Partnumber.&nbsp; &nbsp; &nbsp;Part cost.&nbsp; &nbsp; &nbsp;Part sale date&nbsp; &nbsp;start date.&nbsp; &nbsp; End date</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/10/2019.&nbsp; &nbsp; &nbsp;9/18/2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 23 Nov 2022 14:17:02 GMT ashu237 2022-11-23T14:17:02Z https://community.qlik.com/t5/QlikView/Filter-data-based-on-date-which-should-lie-between-start-date/m-p/2008274#M1221623 <P>I have one table in which I have start date , end date , part number, part sale date, cost. I want filter data by checking if the partsale date lies between start date and end date.</P> <P>Table:</P> <P>Partnumber.&nbsp; &nbsp; &nbsp;Part cost.&nbsp; &nbsp; &nbsp;Part sale date&nbsp; &nbsp;start date.&nbsp; &nbsp; End date</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.99&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/4/2005.&nbsp; &nbsp; &nbsp;6/17/2006</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.99&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; 6/17/2006.&nbsp; 10/4/2010</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/10/2019.&nbsp; &nbsp; &nbsp;9/18/2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Expected result</P> <P>Partnumber.&nbsp; &nbsp; &nbsp;Part cost.&nbsp; &nbsp; &nbsp;Part sale date&nbsp; &nbsp;start date.&nbsp; &nbsp; End date</P> <P>Abcd.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2/29/2020.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7/10/2019.&nbsp; &nbsp; &nbsp;9/18/2022</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 23 Nov 2022 14:17:02 GMT https://community.qlik.com/t5/QlikView/Filter-data-based-on-date-which-should-lie-between-start-date/m-p/2008274#M1221623 ashu237 2022-11-23T14:17:02Z