Computed Columns - SQL Server Function
You wouldn't be able to persist this computed column, as its value needs to change over time.  But having such a non-persisted computed column is a recipe for poor performance.

For this scenario you should decide how often you need to recalculate whether a row is "active" and run a scheduled batch process and/or a trigger to maintain the values.