Operation of datiff in SQL 2014

Question

I have an accumulated base of dates in sql, I wanted to select all dates you have from the current date (today) until 60 days ago, but I’m not getting the code right.

***select
    data
    CPF,
    sum(risco) as risco
    from BASE_ACUMULADA
    where  Data in (datediff(dd, 0, getdate())),(datediff(dd, 0, getdate())-60))
    group by data, CPF***

Answer 1

Try this suggestion using the operator Between:

where Data between dateadd(dd, -60, cast(getdate() as date)) and getdate()

I hope it helps