Loading

Display of previous month sales based on input parametrs

Anilkumar Adepu

I have a SP, where there are two parameters fromdate and todate to get monthly sale value. Now , i have a query, that how can i display the previous month sales for the date set for fromdate and todate parameter.
Request you to please help me on this.

E.g: fromdate='2022-07-01',todate='2022-07-30'
Prevoius month sales required 2022-06-01 ,2022-06-30

1 Reply

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

Muhammad Imran Ansari4y ago
You can use DATEADD() method to achieve this.
-- Parameters
DECLARE @fromdate AS DATE = '2022-07-01'
DECLARE @todate AS DATE = '2022-07-30'

DECLARE @PrevoiusMonth AS BIT = 1

IF @PrevoiusMonth = 1
BEGIN
    SET @fromdate = DATEADD(MM, -1, @fromdate)
    SET @todate = DATEADD(MM, -1, @todate)
END

-- Your actual query and modify according to your table and column
SELECT *
FROM MonthlySale
WHERE SaleDate BETWEEN @fromdate AND @todate