Filter using relative date values ("TODAY" etc.)

This would be extremely helpful. We have set up some reports to monitor the data (for example, to see the list of deals with a past close date). So our users can take certain actions on those deals. Currently whenever I want to get the latest data, I have to manually change the filter. I can’t set up email to push out the reports to relevant users. This is really annoying.