Help Combining Multiple Date Fields from Multiple Data sources Into One Field for a Text Table

Samenvatting

Hey everyone, I for the life of my can't figure out how to accomplish this. I've reviewed scaffolding, pivots, etc but nothing seems to work. Here is the data structure: Table 1: Customer ID and Customer Create Date (All records in this table) Table 2: Customer ID and Customer Order Date (Some of the records in table 1 are in this table) Table 3: Customer ID and Received Date (Some of the records in table 2 are in this table) I am hoping to show a simple text table that has the number of cust...