Date help for Dynamic Year and static Month and Day 1

[dscoiho]

I am using SQL Server 2005. I am trying to get date function where year changes each year but my month and day stay the same. I need for ex... '2008-12-01' current, next year it would be '2009-12-01'. It will always be the beginning of the static month.

Thanks in advance.

 

[bborissov]

SELECT DATEADD(yy,  1,'20081201') -- 01 Dec 2009
SELECT DATEADD(yy, -1,'20081201') -- 01 Dec 2007
SELECT DATEADD(yy, -2,'20081201') -- 01 Dec 2006
SELECT DATEADD(yy, 30,'20081201') -- 01 Dec 2038

So, choose a basic year and then add whatever value you want to year portion

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[LFCfan]

Or, to return the 1st Dec of the year of any given date:

declare @d datetime
set @d = '2003-07-23'
SELECT dateadd(mm,11,DATEADD(yy, DATEDIFF(yy,0,@d), 0))

~LFCfan

 

[dscoiho]

Thanks LFCfan that was the solution.