postgres=# create table adriano10(id int generated always as identity primary key, datum date);
CREATE TABLE
postgres=# insert into adriano10 (datum) select '2019-01-01'::date + s * '1month'::interval from generate_series(0,48) s;
INSERT 0 49
postgres=# select * from adriano10 where datum between current_date - '1year'::interval and current_date;
id | datum
----+------------
29 | 2021-05-01
30 | 2021-06-01
31 | 2021-07-01
32 | 2021-08-01
33 | 2021-09-01
34 | 2021-10-01
35 | 2021-11-01
36 | 2021-12-01
37 | 2022-01-01
38 | 2022-02-01
39 | 2022-03-01
40 | 2022-04-01
(12 rows)
postgres=#