When All Orders is selected, FilterByStartDate and FilterByEndDate both use an OR clause to compare two different dates. In some cases, this can cause orders to be included that should be excluded.
For example, if the date range is all of 2020 (1-Jan-2020 through 31-Dec-2020), and the order has a Proposed Order Posted Date in 2019 and an Executed Date in 2021, then it will be included because the Executed Date is greater than the Start Date and the Proposed Order Posted Date is less than the End Date.
When All Orders is selected,
FilterByStartDateandFilterByEndDateboth use an OR clause to compare two different dates. In some cases, this can cause orders to be included that should be excluded.For example, if the date range is all of 2020 (1-Jan-2020 through 31-Dec-2020), and the order has a Proposed Order Posted Date in 2019 and an Executed Date in 2021, then it will be included because the Executed Date is greater than the Start Date and the Proposed Order Posted Date is less than the End Date.