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

I really need this in workflows and active lists so for example if “renewal is (last month)” I can set up actions to be based on those criteria.