Reporting on "Active" contract

[ibrs]

I want to be able to create a report that list the contracts that are active. That is the contracts where

start_date < today & end_date > today.

I've tried adding fillters however I can't specify Today, I can only manually put in a date, then change this each time I run the report. It would be much more useful to either enable the date filelds in a report to have function like NOW() or support operations like "after today" and "before today"

Another idea is to have a calculated field in the contracts which is

Active - start_date < today & end_date > today;

[jmertic]

I see the option for 'Today' in Sugar 6.1