function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Belinda J. DavidsonBelinda J. Davidson 

extimating the renewal date

Hello
We have a field called "Initial Contract Signature Date" which may be a date field. This field records when the initial contract is signed. A contract are often auto-renewed monthly or annually which is indicated by variety field "Renewal Term Months". i might wish to create a replacement formula field that calculates the "Next Renewal Date".

So if it's a 1 month renewal term, and initial contract date is 12/1/2020, then the "Next Renewal Date" would be 1/1/2021. However, i might love it to automatically update to (https://freeappdownloadhub.com/gta3-apk/) subsequent month when 1/1/2021 has passed... so once I log in on 1/2/2021, the "Next Renewal Date" would update to 2/1/2021.
ANUTEJANUTEJ (Salesforce Developers) 
Hi Belinda,

I think you can have a schedulable apex that runs at a particular time every day and in case if there are any records with the date as today then you can update these fetched records to show the date as next month.

Additionally, you can try checking this link as it seems to have a similar implementation: https://developer.salesforce.com/forums/?id=9060G000000I1LOQA0

Let me know if it helps you and close your query by marking it as solved so that it can help others in the future.  

Thanks.