batgirl (8/23/2013)
sharonsql2013 (8/23/2013)
I am trying to view data for past one year ...Don't know whats wrong with the following:select ProdMonth ,ProdYear from Production
where DATEADD(yyyy,-1,getdate())
Kindly advise
You will need to compare some data column to the calculated date one year ago.
....where DATECOLUMN >= DATEADD(yyyy,-1,getdate())
This is one of the biggest reasons why I try to discourage people from saving parts of dates in separate columns.
What is the datatype of the ProdYear and ProdMonth columns?
--Jeff Moden
Change is inevitable... Change for the better is not.