• select Max(date)

    from

    (select date1 from table1

    union all

    select date2 from table1

    union all

    select date3 from table1 ) as tbl