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