Need help with selecting distinct event date within last 180 days
Select A.SubscriberKey,COUNT(DISTINCT EventDate) AS Count,B.CreatedDate
From _Open A
JOIN _ListSubscribers B
ON A.SubscriberKey = B.SubscriberKey
Where B.ListID = '10630' AND B.CreatedDate Between 'Jan 10 2009' AND 'Nov 06 2012' AND EventDate > (Select DATEADD(day,-180,getdate()))
Group By A.SubscriberKey,B.CreatedDate
I want to select only Distinct Event Date's that have occured in the past 180 days. Query is pulling info, but I am getting a much higher count than is possible for the time frame. For example, the user can only have a max of 60 distinct event dates in the past 180 days and I am getting users that have 1,000+. Is this because the event date is going further back? Thanks for any help!!