Need to test every row against TODAY() to set field value - HOW?

[Lucinda_Mason]

I have a field, ACTIVE, that I want to set to YES if TODAY() is between START_DATE and END_DATE.

Workflow rules seem to be run only when data is ADDED, UPDATED or DELETED.

I need to change the ACTIVE field in every row based on the expression above. How would I do that?