The Renewal Date is a calculated field on a contract record that defines the date by which a decision needs to have been made about the renewal or cancellation of a contract.
In this article you will learn:
What is the Renewal Date on a contract?
How do the Renewal Date filters work?
What is the Renewal Date on a contract?
The Renewal Date of a contract is defined as follows:
Renewal Date = Contract End Date - Notice Period
For example, if the contract ended on 31st December, and the notice period was 60 days, the Renewal Date would be 1st November (31st December minus 60 days).
This date is important, as it defines the date beyond which you have missed the notice period.
How do the Renewal Date filters work?
The Renewal Date Filters are mutually exclusive 'buckets' of contracts, split by Renewal Date. They are defined as follows:
0-30 Days |
Contracts whose renewal date falls 30 days from today's date, including today. For example, if today is 1st January, it will include all contracts whose renewal date is 1st to 31st January, inclusive. |
31-60 Days |
Contracts whose renewal date falls 31 days to 60 days from today's date. For example, if today is 1st January, it will include all contracts whose renewal date is 1st February January to 2nd March, inclusive (assuming no leap year) |
61-90 Days |
Contracts whose renewal date falls 61 days to 90 days from today's date. For example, if today is 1st January, it will include all contracts whose renewal date is 3rd March to 1st April, inclusive (assuming no leap year) |
Beyond Renewal Date |
Contracts whose renewal date is before today's date, but the contract is not yet expired. For example, if today is 1st January, it will include all contracts whose renewal date is 31st December and earlier. |
Expired |
Contracts whose expiry date is any date before today's date. For example, if today is 1st January, it will include all contracts whose expiry date is 31st of December and earlier. |