It can also be done using Pivot Concept...very simple

SELECT Max(date)

FROM (SELECT date

FROM (SELECT date1,

date2,

date3

FROM sample) AS X

UNPIVOT (date

FOR sample IN (date1,

date2,

date3)) AS unpivoty) AS Z