Under Effective Date in Program Settings--> Program Rate Sheets

Add a field called:

Expiration Date (with a calendar)

Once the rate exceeds this Expiration date, if possible, the Rate should then be automatically made INACTIVE