sql get latest of 2 datetimes
SELECT ID,
CASE WHEN
COALESCE(Date1, '1/1/1973') > COALESCE(Date2, '1/1/1973') -- COALESCE is to ensure comparison works when 1 is nullable
THEN Date1
ELSE Date2
END AS MostRecentDate
FROM Table