Home Forums SQL Server 2005 SQL Server 2005 General Discussion Last Year to Date report parameter RE: Last Year to Date report parameter
Dung Dinh
SSCrazy
Points: 2513
More actions
September 15, 2010 at 9:31 am
#1221461
You should use
select dateadd(yy,-1,dateadd(d,-1,getdate()))