Bring records from today's date up to 1 month ago SQLSERVER

You can use DATEADD , this query will return the date in the last month starting from the last midnight

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, DAY(GETDATE())-1)

  

How do I get the records of today's date up to 1 month ago in SQLSERVER?

I suggest that you use the DATEDIFF function.

-- código #1
declare @UmMêsAtrás date;
set @UmMêsAtrás= datediff (month, -1, cast (current_timestamp as date));

--
SELECT ...
  from ...
  where coluna_data >= @UmMêsAtrás;

One must be careful to avoid the implicit conversion in the WHERE clause; thus, the @AnyMore variable must be declared in the same data type as coluna_data . Details on the article The dangers of implicit conversion