Fetch sum of sales column till seven days back from todays date

rohit.so...

SOLVED CLOSED ACTIVE ANSWERED
User: rohit.sood8
Posted: on Jan 16, 2014 04:38 AM
Forum: ASP.Net Web Forms
Answer: 2
Views: 2484

hello sir,

i want to find the sum of sales column from the table. Like today is 16-01-2014, i want the sum of sales column of 7 days back i.e. till 09-01-2014. I cannot put static dates as everyday date will change and every day i want that query to automatically see 7 days back records.

Please suggest.

Thanks

Rohit

Download FREE API for Word, Excel and PDF in ASP.Net

rohit.so...

0 3

Reply
ANSWER
User: rohit.sood8
Replied: on Jan 16, 2014 10:24 PM
Report

Thanks Azim for sharing this query. It was helpful, i have modified it according to my question like:

SELECT SUM(SALE) AS Total FROM Sales
WHERE Saledate < GETDATE()
AND Saledate <=  DATEADD(d,-7, GETDATE())

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Fetch sum of sales column till seven days back from todays date

Company

Explore

Follow us

Contact Us