# COLUMN - IF THEN TODAY's DATE

**URL:** <https://community.glideapps.com/t/column-if-then-todays-date/25301>\
**Category:** Ask for Help\
**Created:** [April 8, 2021, 11:22am UTC](https://community.glideapps.com/t/column-if-then-todays-date/25301 "2021-04-08T11:22:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [April 8, 2021, 11:22am UTC](https://community.glideapps.com/t/column-if-then-todays-date/25301/1 "2021-04-08T11:22:47Z")

</div>

**Situation:** Have a date Column with a value. If this value has past, I need to call Today’s Date instead.

**Solution:?** I’m thinking the way to do this is an IF THEN column that sets to Today’s Date IF the date column is earlier than Today (you can set this criteria in IF THEN)

**However:** I can’t find a way to set the value upon this condition to today’s date. Perhaps I’m missing something here.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 8, 2021, 11:29am UTC](https://community.glideapps.com/t/column-if-then-todays-date/25301/2 "2021-04-08T11:29:21Z")

</div>

You’ll need another math column that outputs today’s Date (Now) and use that in the ITE column.

---

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [April 8, 2021, 12:03pm UTC](https://community.glideapps.com/t/column-if-then-todays-date/25301/3 "2021-04-08T12:03:30Z")

</div>

Thanks - that works.

A little bit of a round about way with additional columns - but I’m coming to understand this is the default approach in glide to resolve these issues. AKA add another column.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 8, 2021, 12:18pm UTC](https://community.glideapps.com/t/column-if-then-todays-date/25301/4 "2021-04-08T12:18:32Z")

</div>

![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb81c5d9ed15989743d79007c961d327b48a00c8.gif)