Hello Tom,
Can you confirm that the Alert that Jason is trying to create should actually work ?
It has been our experience that Filter Alerts only work when entries are changed. For example, if you have a Filter Alert set to run once each day and a Filter that returns entries that are Overdue, it will only send an Alert for entries that were modified in he previous 24 hours (ie since the last time the Alert was processed). Of course, most entries that are Overdue were not modified in the last 24 hours, and are not returned.
We spent hours trying to get this to work. We found that if we manually modified the Last Run Time in the Alerts table we could force it work (by setting the Last Run Time to something very old).
Bottom line is, we don't think Alerts will do what Jason is asking for, even if they are configured correctly.
(Alert Filters are also affected by the bug in non-US dates, which makes them even less useful).
Regards,
Brian