You need to sign in to do that
Don't have an account?
Belinda 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.
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.
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.