automated procedure in sql server

i'm trying to set up a table in sql server that will automatically update based on the date. basically, i want to display a list of dates for a year, given a set interval. when one date passes, i want its status set to inactive, and a new date added with a status of active. i would like this to run every day and check for new dates.

do i need to set up a trigger? a stored procedure?

can someone point me in the right direction, and maybe give me some information to check out? thanks.

You can write a stored procedure that updates the dates. Then set up a job to run the stored procedure every day. To determine how to set up a job, search your Books Online for "jobs, scheduling"