I want to filter other attributes by the following criteria
IF TODAY() > ([DATE] + 30) THEN 'Past Due'
ELSE 'On Schedule' END
[DATE] = my date field
30 = # of days
You have it already.
Put that calc on your filter shelf. Select for whichever one (or both) you want to see.
Retrieving data ...