Change a status when a date is reached

HI,

I'm looking for some advice on how to update a field when a date is reached.

More specifically, we have a Campaigns table that includes a field for Campaign Status and Campaign End Date.

Campaign Status = Planned, Running, Paused, or Completed
Campaign End Date = [MM/DD/YYYY]

When the Campaign End Date is reached, I would like for the Campaign Status to change to Completed.

Is there a good tutorial on this if I wanted to create a Pipeline or maybe other suggestions?

Thanks,

Matt

------------------------------
Mathew Crist
------------------------------