Multiple Date, but need one filter based on all Dates
I have an issue where I need to be able to have multiple date, Order Date, Ship Date, Payment Date.
In my example, I have an Order that has an Order Date in one table, in addition a ship date in another table, and a payment date in another table. I need to link all tables by order number. However I need to be able to have a "Transaction Date" so I can see what happened in a particular month.
For example, Order #123 has an Order Date of 07/31/2017, ShipDate of 08/01/2017, and a PaymentDate of 08/01/2017.
Order #789 has an order date of 07/30/2017, ShipDate of 08/01/2017, and Payment Date of 07/31/2017.
I need to be able to both filter the report on each date, which I am able to do with not problem, but I also want to create a "Transaction Date", that I can filter on. So if I create a "Transaction Date", and say show me everything that happened in the month of August, It would should be the Order#123 because it has transactions (SHIPDATE and PAYMENTDATE) and it would show me Order#789 because it also has transactions (ShipDate).
I can't seem to do this without it creating a loop.