# Future date formula

**URL:** <https://community.blaze.today/t/future-date-formula/36970>\
**Category:** Questions and Help\
**Created:** [April 10, 2024, 11:38am UTC](https://community.blaze.today/t/future-date-formula/36970 "2024-04-10T11:38:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paddy\_O\_Rourke](https://community.blaze.today/user_avatar/community.blaze.today/paddy_o_rourke/32/11113_2.png) [@Paddy\_O\_Rourke](https://community.blaze.today/u/Paddy_O_Rourke)\
**Post date:** [April 10, 2024, 11:38am UTC](https://community.blaze.today/t/future-date-formula/36970/1 "2024-04-10T11:38:38Z")

</div>

Hi, I'm looking for a way to automatically enter "today's" date plus X number of days, ie "today + 730 days, or "today + 154 days. How could I achieve this?

---

<div class="post-metadata">

**Author:** ![Mansur\_Kutybayev](https://community.blaze.today/user_avatar/community.blaze.today/mansur_kutybayev/32/5897_2.png) [@Mansur\_Kutybayev](https://community.blaze.today/u/Mansur_Kutybayev)\
**Post date:** [April 10, 2024, 12:00pm UTC](https://community.blaze.today/t/future-date-formula/36970/2 "2024-04-10T12:00:14Z")

</div>

Hi @Paddy_O_Rourke,

You can use `time` command with `shift` setting. Here is an example which will display today + 154 days. You can choose different display formats.

{time: YYYY-MM-DD; shift=+154D}

---

<div class="post-metadata">

**Author:** ![Paddy\_O\_Rourke](https://community.blaze.today/user_avatar/community.blaze.today/paddy_o_rourke/32/11113_2.png) [@Paddy\_O\_Rourke](https://community.blaze.today/u/Paddy_O_Rourke)\
**Post date:** [April 10, 2024, 2:36pm UTC](https://community.blaze.today/t/future-date-formula/36970/3 "2024-04-10T14:36:34Z")

</div>

Excellent, that works. Now for another one, please.

I would like to automatically enter a date 14 days before the date I enter. So the date I enter will vary but the date I need inserted will always be 14 days before it. Any idea?

---

<div class="post-metadata">

**Author:** ![AshwinMittal](https://community.blaze.today/user_avatar/community.blaze.today/ashwinmittal/32/18048_2.png) [@AshwinMittal](https://community.blaze.today/u/AshwinMittal)\
**Post date:** [April 11, 2024, 3:31am UTC](https://community.blaze.today/t/future-date-formula/36970/4 "2024-04-11T03:31:13Z")

</div>

Hi @Paddy_O_Rourke,

You can use [our date function](https://blaze.today/formulas/reference/#date-time-functions) and `formatter` setting in [{formdate} command](https://blaze.today/commands/formdate/) to finally insert a date 14 days before the selected one.

{formdate: YYYY-MM-DD; formatter=(value)-\> datetimeformat(datetimeadd(value, -14, "D"), "YYYY-MM-DD")}

---

<div class="post-metadata">

**Author:** ![Paddy\_O\_Rourke](https://community.blaze.today/user_avatar/community.blaze.today/paddy_o_rourke/32/11113_2.png) [@Paddy\_O\_Rourke](https://community.blaze.today/u/Paddy_O_Rourke)\
**Post date:** [April 11, 2024, 9:34am UTC](https://community.blaze.today/t/future-date-formula/36970/5 "2024-04-11T09:34:42Z")

</div>

Epic, excellent support, thank you