i think that main question is hidden in noticing @Date2 is defined first and @Date1 is defined later..

DECLARE @DATE1 DATETIME

DECLARE @DATE2 DATETIME

SELECT @DATE2 = '2 jan 2010'

SELECT @DATE1 = '4...