Loading

I need to display last 3 years Records Only

Thulasiram pakala

9y869.NET

Hi,

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradeep Sahoo9y ago
You can write a stored procedure to fetch the data . Write the sql query inside Stored procedure .
D Donthu9y ago
In Sql server
SELECT OrderId,DATEADD(year,-3,getDate()) AS OrderPayDate
FROM Orders.

please ref the below Url per add day,month,year

http://www.w3schools.com/sql/func_dateadd.asp
Francis Susaimichael9y ago
Have you tried something? if so, share your SQL query.