I agree I keep hearing how you need ETL tools, people don t know how to import and export data. I never needed anything outside of SQL server

select Max(date)

from

(select date1 from table1

union all

select date2 from table1

union all

select date3 from table1 ) as tbl