function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
MohandaasMohandaas 

Scenario using TODAY() formula field

Here is my requirement. In contract I have an end date field. On the last date of expiry If the other field renewal is set true the contract end date should be extended by an year.

 

My question is using a custom formula field TODAY() will that fire an update trigger or workflow action everyday so I can check whether te contract expires today.

 

I am sorry If I am stupid. 

Shashikant SharmaShashikant Sharma

You can write a scheduler which you can schedule to run ever day pick all the contracts which expire today and if set to renewal then update expiry date in them. If it suits you I can help you in writing scheduler class.
MohandaasMohandaas

Thanks Shashi.

 

Even I thought of acomplishing using a scheduler class. Just felt I am missing something that brought out Einstein in me :)

 

 
Shashikant SharmaShashikant Sharma

There is no option other then scheduler for you, please let me know if you can find any other.
BritishBoyinDCBritishBoyinDC

Wouldn't a time-based workflow achieve this as well?

 

On Contract Create/Activate or something, set a time-based workflow to fire on the contract expiration date...if the renewal is set, do a field update to extend contract to be Contract + a year?