declare @Now char(8),
@AYearAgo char(8)
set @Now=convert(char(8),getdate(),112)
set @AYearAgo = convert(char(8),dateadd(year,-1,@Now),112)
select Field1, Field19 from MyTable where CreateDate between @AYearAgo and @Now
--or just use the one variable
select Field1, Field19 from MyTable where CreateDate >= @AYearAgo