How to Calculate Days Until Renewal in HubSpot
By Ulas ArslanPublished
You do not always need a formula to calculate days until renewal in HubSpot. Use a relative date filter when you need a working list, show relative time when a user needs context on the record, and create a Time until property only when the duration must be reused. Every option still depends on one valid renewal date.
Use the simplest option that fits the job
Start with the decision you need to support. A countdown on a record, a daily work queue, a report and a timed workflow are different jobs. Building one calculation property for all four can add limits without improving the process.
HubSpot’s current guide to today’s date in the CRM describes relative display, date filters and Time until calculation properties as separate options.
| Need | Best starting option | Why |
|---|---|---|
| Context on one record | Show relative time on the Renewal date | Adds a readable distance without changing the source value |
| A list of renewals due soon | Filter the Renewal date relative to today | Keeps the rule on the verified source date |
| A reusable duration field | Create a Time until property | Makes the duration available in supported views and automation |
| An action on a fixed day | Use a date-based workflow or delay | Schedules the action from the source date |
Show relative time on the renewal date
If users only need to see how far away a renewal is, edit the date property and enable Show date with relative time. HubSpot then shows a value such as 45 days from today beside the stored date. The option works for date picker and date and time picker properties.
This display does not change the property value. It is useful on a Company record, but HubSpot says the relative label is not supported in forms, reports or the mobile app. Keep the original date visible because that is the commercial fact.
Build a working view without a new calculation
For a renewal queue, filter the source date directly. This is often easier to review than a second property whose only job is to restate the date.
- Open the Company index and choose Advanced filters.
- Set Renewal date to is known.
- Add Renewal date is less than 60 days from now.
- Exclude past dates or place them in a separate exception view.
- Add Company owner is known if the view is meant for action.
- Save a second view for Renewal date is unknown.
Create a Time until property when teams need one field
Use a Time until property when the duration itself must be reused in supported Company views, segments, workflows or single-object reports. HubSpot lists this calculation type for eligible Professional and Enterprise subscriptions.
In Settings, open Properties, select Company properties and create a Calculation field. Choose Time until, then select the verified Renewal date as the end date. HubSpot uses today as the start date. Its calculation property documentation notes that you cannot later change the calculation from Time until to another type, although you can change the selected date property.
A worked 45-day renewal example
Example: Northstar Ltd has a verified Company renewal date of 31 December 2026. On 16 November 2026, the renewal is 45 days away. The same source date can support several outputs without becoming several sources of truth.
If the date later changes to 31 January 2027, the filter and Time until value can update. That does not prove the new date is valid. Check the contract evidence and property history before treating the change as a commercial fact.
| Output | Example result | What it means |
|---|---|---|
| Relative display | 31 Dec 2026, 45 days from today | Readable context on the record |
| 60-day Company view | Northstar is included | The renewal falls inside the review window |
| Time until property | 45 days | A reusable duration in supported tools |
| Workflow action | Task scheduled 30 days before, on 1 Dec | A timed action from the source date |
| Unknown-date queue | Not included | Missing timing needs a separate review |
Trigger work from the source date
A daily countdown is not required when the goal is one action at a known point. HubSpot workflows can delay until a date property and continue on the date, before it or after it. The workflow delay guide also supports branches for a date that has passed or is unknown.
For recurring date checks, HubSpot advises using a scheduled enrollment trigger instead of using today as a re-enrollment trigger. Test re-enrollment, duplicate tasks and past dates before publishing. One date should not create a new task every day.
Test six cases before rollout
Use test Companies that represent the real failure modes, not only one clean record. Inspect the source value, calculated output and final workflow state.
- A valid renewal date inside the review window.
- A valid date outside the review window.
- A missing renewal date.
- A renewal date already in the past.
- A date changed after a task was scheduled.
- A date copied between date picker and date and time fields.
Know the reporting and time limits
HubSpot says Time since and Time until properties are not supported in datasets, custom report builder filters, inputs to other calculation or rollup properties, or custom data sync field mappings. Use the original Renewal date in those places when the tool supports relative date filters.
For a date property without a timestamp, HubSpot uses 12:00 am UTC in the calculation. The displayed duration also changes units: values of three months or more appear in months, while shorter values may appear in days, hours or minutes. Do not assume the visible label will always be an exact integer number of days.
Keep timing separate from renewal risk
Days until renewal answers when. It does not answer whether the customer will leave, whether follow-up is adequate or whether the account has an owner. A quiet account may need review, but activity is not confirmed churn.
Renewal Radar resolves supported timing evidence with deterministic rules and shows the winning source and confidence. A scan is still a point-in-time result, not a live mirror of every later CRM edit. Compare the scan time with the current HubSpot value, then review how renewal timing is resolved before taking action.
