I thought I had posted my reply prior so I apologize if this is a duplicate post...

Here is an alternative you may want to try to get the max date...

I thought this would be an easy one but had to get some help too. Try this...

declare @dt table ( akey int, d1 datetime, d2 datetime, d3 datetime )

insert...