# Days Since Close property

**URL:** <https://community.hubspot.com/t/days-since-close-property/138079>\
**Category:** CRM\
**Tags:** professional\
**Created:** [August 15, 2025, 2:05pm UTC](https://community.hubspot.com/t/days-since-close-property/138079 "2025-08-15T14:05:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JTeagle](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@JTeagle](https://community.hubspot.com/u/JTeagle)\
**Post date:** [August 15, 2025, 2:05pm UTC](https://community.hubspot.com/t/days-since-close-property/138079/1 "2025-08-15T14:05:16Z")

</div>

So, my overall goal is to create a property in HubSpot that calculates a customers’ total average spend based on rolling time frames (e.g. last 90 days, last 365 days).

This is proving more challenging than we anticipated.

To start with we thought creating a deal property ‘Days since close’ that calculates the number of days between today and the deal close date would help us get closer to the average, however i can’t find a way as i don’t think you can have a property for ‘today’s date’.

I found this forum idea but not sure if it is the right soltution for this: [https://community.hubspot.com/t5/CRM/Closed-Won-Deals-in-the-last-N-days-LIST/m-p/1164406](https://community.hubspot.com/t5/CRM/Closed-Won-Deals-in-the-last-N-days-LIST/m-p/1164406)

If anyone has any ideas they are appreciated!

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [August 15, 2025, 2:12pm UTC](https://community.hubspot.com/t/days-since-close-property/138079/2 "2025-08-15T14:12:36Z")

</div>

Hi @JTeagle,

This should be doable with a calculation and a rollup property:

- First, create a deal “time since” property that calculates the time since the close date: [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)
- On the company object, create a roll up property that sums up the amount of the associated deals and, as a condition, add the time since property you created: [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)

The time since condition is a new feature (as of this week), let me know if you’re seeing it or not.

Best regards!

---

<div class="post-metadata">

**Author:** ![JTeagle](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@JTeagle](https://community.hubspot.com/u/JTeagle)\
**Post date:** [August 19, 2025, 8:48am UTC](https://community.hubspot.com/t/days-since-close-property/138079/3 "2025-08-19T08:48:09Z")

</div>

Amazing yes this works! I used the time since function to create the time since close property on the deal. Then a roll up property for ‘total spend in the last 90 days’ then a calculation property that divides the total spend by 3 for the average monthly spend

---

<div class="post-metadata">

**Author:** ![SRush9](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@SRush9](https://community.hubspot.com/u/SRush9)\
**Post date:** [November 13, 2025, 8:29pm UTC](https://community.hubspot.com/t/days-since-close-property/138079/4 "2025-11-13T20:29:57Z")

</div>

What’s you final Company Rollup field look like? I cannot get this to work correctly.  
My **Time Since Close** field on the deal gives me the correct values on the Deal object:

 ![Screenshot 2025-11-13 at 2.28.13 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/0/0d88f4c86c485a39655663218eed426e2b20f580.png)

but when I go to pass it into the Company Rollout; it doesn’t work. Here is my Rollup:

 ![Screenshot 2025-11-13 at 2.21.43 PM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/2/26d067ab8e45613533d24e1a26ccadfc6050b4e8.png)

As you can see, the condition isn’t just giving me \< 1 year, but suffix terms like ago and now which breaks the logic. Help me Obi Wan.