I need to display last 3 years Records Only

Question

Hi I need to display last 3 years Records Only dispay on grid view

D Donthu · Answer

In Sql server SELECT OrderIdDATEADD( year -3getDate()) AS OrderPayDate FROM Orders. please ref the below Url per add daymonthyear http://www.w3schools.com/sql/func_dateadd.asp

Francis · Answer

Have you tried something? if so share your SQL query.

Pradeep Sahoo · Answer

You can write a stored procedure to fetch the data . Write the sql query inside Stored procedure .