 <pre><code>DECLARE @FixedDate DATE = '2014-11-01'; DECLARE @NextYearFixed DATE = DATEADD(year, 1, @FixedDate) -- 2015-11-01 DECLARE @PreviousYearFixed DATE = DATEADD(year, -1, @FixedDate) -- 2013-11-01 </code></pre>