My first thought would be to do the case statement shown earlier. This seems to be cleaner code if someone else has to look at it in the future.

To those that are doing the 'Union All'. If you are trying to get the max date wouldn't just using the 'Union' statement be more efficient? Since doing just 'Union' will eliminate any duplicate entries. 'Union All' puts in every entry into the result set.