SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) 
 Jul 25 2020 11:26:55 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table receipt (datetimeinsert date, part_no int, qty int);
insert into receipt values ('2021-11-25', 4, 12);
insert into receipt values ('2021-10-25', 4, 12);
insert into receipt values ('2021-09-25', 4, 12);
insert into receipt values ('2021-08-25', 4, 12);
insert into receipt values ('2021-07-25', 4, 12);
insert into receipt values ('2021-06-25', 4, 12);
insert into receipt values ('2021-05-26', 4, 12);
insert into receipt values ('2021-05-25', 4, 12);
insert into receipt values ('2021-04-26', 4, 12);
insert into receipt values ('2021-04-25', 4, 12);
insert into receipt values ('2021-03-25', 4, 12);
insert into receipt values ('2021-02-25', 4, 12);
insert into receipt values ('2021-01-25', 4, 12);
13 rows affected

select datetimeInsert, Part_no,qty
  from receipt 
 where datediff(month, datetimeInsert, getdate()) = 6


datetimeInsert
Part_no
qty


2021-05-26
4
12

2021-05-25
4
12


select datetimeInsert, Part_no,qty
  from receipt 
 where datetimeInsert >= DATEADD(DAY, 0, DATEDIFF(DAY, 0, DATEADD(MONTH, -7, GETDATE())))
   and datetimeInsert < DATEADD(DAY, 0, DATEDIFF(DAY, 0, DATEADD(MONTH, -6, GETDATE())));


datetimeInsert
Part_no
qty


2021-05-25
4
12

2021-04-26
4
12


-- difference in results compared to @larnu's answer and 
SELECT DATEADD(DAY, 1, EOMONTH(GETDATE(),-7))
SELECT DATEADD(MONTH, -7, GETDATE())
SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0, DATEADD(MONTH, -7, GETDATE())))


(No column name)


2021-05-01




(No column name)


2021-04-26 08:59:23.420




(No column name)


2021-04-26 00:00:00.000


-- @larnu's answer
SELECT datetimeInsert,
       Part_no,
       qty
FROM dbo.receipt
WHERE datetimeInsert >= DATEADD(DAY, 1, EOMONTH(GETDATE(),-7))
  AND datetimeInsert < DATEADD(DAY, 1, EOMONTH(GETDATE(),-6));


datetimeInsert
Part_no
qty


2021-05-26
4
12

2021-05-25
4
12