# Ability to increase or decrease date picker properties as a custom calculated property

**URL:** <https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196>\
**Category:** HubSpot Ideas\
**Tags:** workflows\
**Created:** [January 17, 2020, 10:06pm UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196 "2020-01-17T22:06:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AdamSavage](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/adamsavage/32/52876_2.png) [@AdamSavage](https://community.hubspot.com/u/AdamSavage)\
**Post date:** [January 17, 2020, 10:06pm UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/1 "2020-01-17T22:06:26Z")

</div>

We have multiple trials that have 30 day expiring keys and we are unable to have a form pass over the expiration date. It would be bennificial if we were able to create a date centric custom calculated field that could be increased by 30 days. This could be done via workflows, similar to the “Increase Contact Property” or possibly an alteration of the date stamp action, “Stamp date: (a) Static Date (b) Date of Action (c) # days/weeks after date of action”

---

<div class="post-metadata">

**Author:** ![ClemOaky](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/clemoaky/32/15722_2.png) [@ClemOaky](https://community.hubspot.com/u/ClemOaky)\
**Post date:** [April 2, 2020, 11:01am UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/2 "2020-04-02T11:01:31Z")

</div>

Absolutely. We need this in order to calculate when is the renewal date coming to our contracts. The length of the contract varies. This seems like something any SaaS provider needs?

---

<div class="post-metadata">

**Author:** ![dave-ops](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dave-ops/32/99730_2.png) [@dave-ops](https://community.hubspot.com/u/dave-ops)\
**Post date:** [November 16, 2020, 8:22pm UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/3 "2020-11-16T20:22:35Z")

</div>

Same here. Looking to add one day to a subscription end date to show a subscription renewal date.

---

<div class="post-metadata">

**Author:** ![Mhutton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mhutton/32/82797_2.png) [@Mhutton](https://community.hubspot.com/u/Mhutton)\
**Post date:** [March 15, 2021, 11:14am UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/4 "2021-03-15T11:14:31Z")

</div>

Yes, would be good to update expiry date and use new date created for relaying an offer expiry date to a customer as part of an automated process.

---

<div class="post-metadata">

**Author:** ![brianserocke](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/brianserocke/32/13210_2.png) [@brianserocke](https://community.hubspot.com/u/brianserocke)\
**Post date:** [March 17, 2022, 7:11pm UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/5 "2022-03-17T19:11:41Z")

</div>

We would like to see this idea implemented as something that can be done in the Workflows actions UI as well. Our use case involves setting a future expiration date on a contact property relative to a start date for access to training courses.

For example, if I set a date stamp for a start date in a workflow, at the same time I’d like to set an expiration date for 6 months from the start date. This way, I can trigger renewal reminder emails before the expiration date as well as post-expiration follow-up emails.

It would be great to have an option like @AdamSavage mentions where an option is added to the “Set property value” action for date picker properties that allows a certain period of time (months and days) from now (or even relative to another date picker property) to be added and set for the property.

---

<div class="post-metadata">

**Author:** ![Mhutton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mhutton/32/82797_2.png) [@Mhutton](https://community.hubspot.com/u/Mhutton)\
**Post date:** [June 28, 2023, 1:55pm UTC](https://community.hubspot.com/t/ability-to-increase-or-decrease-date-picker-properties-as-a-custom-calculated-property/18196/6 "2023-06-28T13:55:17Z")

</div>

I notice that very recently (5 days ago) this idea was delivered: [https://community.hubspot.com/t5/HubSpot-Ideas/Display-Calculated-Deal-Property-in-Currency-Format/idi-p/252997](https://community.hubspot.com/t5/HubSpot-Ideas/Display-Calculated-Deal-Property-in-Currency-Format/idi-p/252997). In the explanation for this: [Create calculation and rollup properties](https://knowledge.hubspot.com/crm-setup/create-calculation-properties) it mentions dates and how you can calculate a difference between two properties but it still did not allow for a formula of ‘Date + 30 days’ for example. I’ve done some testing and spoken with support but you definitely cannot just add or minus X days from a date as a new property.

This seems like such a straight forward thing to include with the work that was done and seems like a missed opportunity as this would have solved this idea without the need to modify the workflow ‘Increase Contact Property’ function (though that would still be nice to have as well!).
