# How do I conditionally calculate a date?

**URL:** https://forums.knack.com/t/how-do-i-conditionally-calculate-a-date/7753
**Category:** Get Answers
**Created:** [January 7, 2016, 9:02pm UTC](https://forums.knack.com/t/how-do-i-conditionally-calculate-a-date/7753 "2016-01-07T21:02:28Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Randall](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/randall/32/153_2.png) [@Randall](https://forums.knack.com/u/Randall)
#### Post date: [January 7, 2016, 9:02pm UTC](https://forums.knack.com/t/how-do-i-conditionally-calculate-a-date/7753/1 "2016-01-07T21:02:28Z")

</div>

Hello, I'm able to calculate a date, however I have another field on the table that should dictate how the date is calculated. Is this possible?

---

<div class="post-metadata">

### Author: ![JeremyNels15348](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jeremynels15348/32/156_2.png) [@JeremyNels15348](https://forums.knack.com/u/JeremyNels15348)
#### Post date: [March 19, 2016, 5:55pm UTC](https://forums.knack.com/t/how-do-i-conditionally-calculate-a-date/7753/2 "2016-03-19T17:55:32Z")

</div>

In our situation, we'd like a date field on a new record to default to today + 2 weeks.

---

<div class="post-metadata">

### Author: ![BradStevens](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/bradstevens/32/140_2.png) [@BradStevens](https://forums.knack.com/u/BradStevens)
#### Post date: [January 8, 2016, 8:32pm UTC](https://forums.knack.com/t/how-do-i-conditionally-calculate-a-date/7753/3 "2016-01-08T20:32:08Z")

</div>

What are you trying to achieve with the date Randall?