Without a sample of what you're working with, I can only speculate that you might want to consider a T/F calculation based on the equation you specified above ([Date of Game]< Today()). Doing this will place a T/F symbol beside the calculated field name. Place this field on the filters shelf and select TRUE.
This should filter all data to show only those records where the date of the game is before today.
If this doesn't work for you, please consider taking a subset of your data and creating a packaged workbook with it - of course, protect the innocent if names and contact info is present.
Hope this helps,
I figured out a formula for a filter that works. Here it is in case it is helpful for anyone else...
IF ([Event Date]> Today()-1) and [Price Type Class] == "STDNT (STUDENT)"
Then I use this as a filter and exclude. This includes the student tickets after the game is played, but excludes them prior to the event. thanks, John