How to subtract 1 day from a quarter?

Question

SQL Server

Hello!
You need to get data with the creation date "greater than or equal to the current quarter - 1 day". Tried like this:

datepart(dd, CreatedDate) >= dateadd(dd, -1, DATEPART(qq, getdate()))
and datepart(yy, CreatedDate) = datepart(yy, GETDATE())

But it gives out data for half a year. Can anyone advise?

Answer 1

select  dateadd(qq, datediff(qq, 0, getdate()), 0)  -- начало текущего квартала
    
select  dateadd(dd, -1, dateadd(qq, datediff(qq, 0, getdate()), 0) )  -- начало текущего квартала - 1 день.
    
-- CreatedDate >= dateadd(dd, -1, dateadd(qq, datediff(qq, 0, getdate()), 0) )