Change a status when a date is reached

Question

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 CompletedCampaign 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------------------------------

markshnier__you · Answer

I would keep it simple and just use a formula.&nbsp;
I would have a status update field which can be updated manually and then a formula field, called [Status]IF(Today() &gt; [Campaign End Date], "Completed", [Status Update])
&nbsp;------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

mathewcrist · Answer

Hi Mark, I was able to get this to work. There would be a few benefits to making it a little more complex, and not creating a separate formula field, but I think this is good enough for now.

Thanks!

Matt

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

Forum Discussion

Change a status when a date is reached

2 Replies