# Allow calculated properties to use date functions

**URL:** <https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695>\
**Category:** HubSpot Ideas\
**Tags:** object\
**Created:** [June 23, 2022, 8:28pm UTC](https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695 "2022-06-23T20:28:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryceanelson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bryceanelson/32/62359_2.png) [@bryceanelson](https://community.hubspot.com/u/bryceanelson)\
**Post date:** [June 23, 2022, 8:28pm UTC](https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695/1 "2022-06-23T20:28:10Z")

</div>

There are a few instances where we are tracking critical price increase and contract renewal options with our deals. Calculated properties are great, but they would be spectacular if we could perform date functions (like edate() in excel) using existing properties.

For example, let’s say our contracts automatically renew every 12 months. I would like a custom calculated property be able to automatically determine the next renewal date is and then use a workflow to alert the pertinent individuals.

Deal.LastRenewal = 1/1/2022

Deal.RenewalTerm = 12

It would be great if Hubspot could just have a calculated property that adds those two together to return a Deal.NextRenewal date.

---

<div class="post-metadata">

**Author:** ![thorndikedev](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thorndikedev/32/30191_2.png) [@thorndikedev](https://community.hubspot.com/u/thorndikedev)\
**Post date:** [July 5, 2022, 5:27pm UTC](https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695/2 "2022-07-05T17:27:11Z")

</div>

Yes. Essentail. Similarly we offer a warranty that lasts for 1 year from their closing date. I would love to be able to set the warranty expiration date to be the close date + 1 year. Right now that is not possible.

---

<div class="post-metadata">

**Author:** ![YoelBA-GDS](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/yoelba-gds/32/69265_2.png) [@YoelBA-GDS](https://community.hubspot.com/u/YoelBA-GDS)\
**Post date:** [August 4, 2022, 7:31pm UTC](https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695/3 "2022-08-04T19:31:35Z")

</div>

I have a SaaS client offering Subscriptions, and it would be valuable from a marketing perspective to be able to communicate with the subscriber based upon their subscription date or subscription expiry date example:

Expiry Date == Today + 90

---

<div class="post-metadata">

**Author:** ![WStoffberg](https://avatars.discourse-cdn.com/v4/letter/w/c67d28/32.png) [@WStoffberg](https://community.hubspot.com/u/WStoffberg)\
**Post date:** [November 1, 2022, 4:30pm UTC](https://community.hubspot.com/t/allow-calculated-properties-to-use-date-functions/59695/4 "2022-11-01T16:30:23Z")

</div>

This is great for reporting, forecasting and managing future workloads. If we are able to predict when certain deadlines will fall we can ensure that teams and resources and prepared. Incredible potential with tickets and dashboards.