Getting previous month of last year

Question

I want to get the previous month data but of the following year. So if it's May 2022, I want the data for April 2021.

Here is what I currently have, but it is showing the date for 12 entire months and not just 1. Any advice would be great.

AND b.invoice_date >= DATEADD(MONTH, -12, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0))                                 
AND b.invoice_date < DATEADD(MONTH, DATEDIFF(MONTH, -11, GETDATE()), 0) 

Answer 1

If you can use variables

DECLARE @StartDate DATETIME, @EndDate DATETIME
SET @StartDate = DATEADD(MONTH, DATEDIFF(MONTH, 0, getdate()) - 13, 0)
SET @EndDate = DATEADD(mm, 1, @StartDate)

SELECT * FROM TABLE b
WHERE b.invoice_date >= @StartDate                         
AND b.invoice_date < @EndDate