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.
Table:
Partnumber. Part cost. Part sale date start date. End date
Abcd. 0.99 2/29/2020. 8/4/2005. 6/17/2006
Abcd. 0.99 2/29/2020. 6/17/2006. 10/4/2010
Abcd. 1.1. 2/29/2020. 7/10/2019. 9/18/2022
Expected result
Partnumber. Part cost. Part sale date start date. End date
Abcd. 1.1. 2/29/2020. 7/10/2019. 9/18/2022