MySQL 8.0

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

create temporary table invites (
  id int,
  date_created_utc datetime,
  note VARCHAR(32)
);

INSERT INTO invites VALUES
(1, '2020/06/01', 'should not appear in list'),
(2, '2020/09/16', 'should appear in list'),
(3, '2020/12/15', 'should appear in list'),
(4, '2021/03/16', 'should appear in list'),
(5, '2021/06/17', 'should appear in list'),
(6, '2021/09/25', 'should not appear in list'),
(7, '2021/12/18', 'should appear in list'),
(8, '2022/03/16', 'should appear in list'),
(9, '2022/06/16', 'should appear in list'),
(10, '2022/09/16', 'should appear in list');

SET @days_span = 90;
SET @days_variance = 2;
SET @today = '2022/09/16';

SELECT 
  invites.id,
  invites.date_created_utc,
  invites.note
FROM
  invites
WHERE
  invites.date_created_utc BETWEEN date_sub(@today, interval (@days_span + @days_variance) DAY) AND @today
  OR invites.date_created_utc BETWEEN date_sub(@today, interval (@days_span + @days_variance) * 2 DAY) AND date_sub(@today, interval (@days_span - @days_variance) DAY);

Records: 10  Duplicates: 0  Warnings: 10

id	date_created_utc	note
8	2022-03-16 00:00:00	should appear in list
9	2022-06-16 00:00:00	should appear in list
10	2022-09-16 00:00:00	should appear in list