Code to retrieve dates for prior year

[TallGuyinIT]

I am not familiar with the SQL program language. I am just trying to make a quick modification to a program. The program is suppose to pull records from 01/01/lastyear to today/lastyear (01/01/2006-05/17/2006). I can tell that the code is not correct based on the data retrieved. Can anyone give me a fix? The current code reads:

WHERE inv_hdr.inv_date >= dateadd(d,-datepart(dy,getdate()-360) + 1,getdate()-360) -- Last years Jan 1.
AND inv_hdr.inv_date <= dateadd(yyyy,-1,getdate()) -- Todays date last year

Thank you

 

[SQLDenis]

the code you have returns this

select dateadd(d,-datepart(dy,getdate()-360) + 1,getdate()-360),dateadd(yyyy,-1,getdate())

2006-01-01 12:27:21.890
2006-05-17 12:27:21.890


Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[SQLDenis]

this
select dateadd(yy, datediff(yy, 0, getdate())-1, 0)

will give you
2006-01-01 00:00:00.000


this
select dateadd(yy,-1,dateadd(dd, datediff(dd, 0, getdate())+0, 0))

will give you
2006-05-17 00:00:00.000

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions