# Calculating new date value

**URL:** <https://community.noloco.io/t/calculating-new-date-value/643>\
**Category:** Ask for Help\
**Created:** [May 5, 2024, 3:41am UTC](https://community.noloco.io/t/calculating-new-date-value/643 "2024-05-05T03:41:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![esben](https://avatars.discourse-cdn.com/v4/letter/e/e47c2d/32.png) [@esben](https://community.noloco.io/u/esben)\
**Post date:** [May 5, 2024, 3:41am UTC](https://community.noloco.io/t/calculating-new-date-value/643/1 "2024-05-05T03:41:53Z")

</div>

Hi,  
I’m trying to calculate when a warranty expires for a list of product in a table. In the product table I have a purchase date and in a linked/related table I have list of duration of the warranty (in months) for that product type.  
Is there a way I can calculate to warranty expiration in my product table? Basically adding a number of months to a date.

Thanks for the help!

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [May 7, 2024, 9:19am UTC](https://community.noloco.io/t/calculating-new-date-value/643/2 "2024-05-07T09:19:35Z")

</div>

Hi @esben, not sure this is the same as what you need but I also need to add periods to dates, in my case years.

This works for me, maybe it helps? I spent a while on this until I realised I couldn’t use a formula field result in a new formula field.

In this example I am adding Years (Product Term) to a date (Signedupdate)

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/1edb22a5ddfac9fa90be838671c1687a2d3093e3.png)

---

<div class="post-metadata">

**Author:** ![esben](https://avatars.discourse-cdn.com/v4/letter/e/e47c2d/32.png) [@esben](https://community.noloco.io/u/esben)\
**Post date:** [May 11, 2024, 2:27pm UTC](https://community.noloco.io/t/calculating-new-date-value/643/3 "2024-05-11T14:27:09Z")

</div>

Thanks! This is super helpful. Somehow I’m unable to select date as type when creating a formula field. Am I missing anything?

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/2f67f9a6b0b74a7e77a93595d275f235b03371f1.png)

---

<div class="post-metadata">

**Author:** ![esben](https://avatars.discourse-cdn.com/v4/letter/e/e47c2d/32.png) [@esben](https://community.noloco.io/u/esben)\
**Post date:** [May 11, 2024, 4:33pm UTC](https://community.noloco.io/t/calculating-new-date-value/643/4 "2024-05-11T16:33:10Z")

</div>

Ah, I figured it out after a lot of testing and taking hints from this answer. Thanks!