Support Portal

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 INNER JOIN MessageList m ON t.TrafficId = m.TrafficId

                          INNER JOIN RecipientList r ON m.RecipientListId = r.RecipientListId

WHERE t.LogDate BETWEEN @StartDate AND @EndDate

                -- AND t.Sent = 1

                AND r.Recipient = 'john.smith@yourdomain.com'

ORDER BY t.LogDate, t.Sender