How to search records until the previous month?

Question

I need to get all the data, from the beginning to the previous month, this query has to be dynamic, I can not put a fixed date, because next month we need to consult again...

In summary, today I need to get all the data until the day 28/02/2021 and next month until the day 31/03/2021 and so on.

Answer 1

    ... where DATEPART(m, _DATA_ ) = DATEPART(m, DATEADD(m, -1, getdate())) 
                 

Extract the month of the date

DATEPART(m, DATE )

and compares by decreasing one month from the current date

DATEPART(m, DATEADD(m, -1, getdate()))