Sorry, my previous post included some mistakes.

here is the corrected code:

SELECT CASE

WHEN @date1Max >= @date2Max AND @date1Max >= @date3Max THEN @date1Max

WHEN @date2Max >= @date1Max AND @date2Max >= @date3Max THEN @date2Max

ELSE @date3Max

END AS GrandMax;