DECLARE @PastDays INT = 30


DECLARE @EndDate DATE = GETDATE()

DECLARE @StartDate DATE = DATEADD(DAY, -@PastDays, @EndDate)


PRINT @StartDate

PRINT @EndDate


SELECT t.LogDate, t.Sender, t.Subject

FROM Traffic t

WHERE t.LogDate BETWEEN @StartDate AND @EndDate

                AND t.Sent = 1

ORDER BY t.LogDate, t.Sender