I'm trying to identify the players who's last gaming date was between 180 and 187 days ago so we can end them a mailer. In other words, I if I ran the query today (3/4/09) I would want to select all players who had a gaming date between 8/29/08 and 9/5/08, but no gaming days since then.

 

I created a group field that shows "max" of gaming date, and then tried to create a record selection using the following formula:

 

datediff("d",Maximum ({CDS_STATDAY.GamingDate}, {CDS_ACCOUNT.Account_ID}),currentdate)>180 or
datediff("d",Maximum ({CDS_STATDAY.GamingDate}, {CDS_ACCOUNT.Account_ID}),currentdate)<= 187

 

But it doesn't work. it still gives me records of players who had a gaming day from February '09, for example.

 

Any suggestions?