# How can I add dates other than TODAY in IFTTT?

**URL:** https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805
**Category:** Ask for Help
**Created:** [November 20, 2021, 8:07am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805 "2021-11-20T08:07:47Z")
**Posts on this page:** 11
**Page:** 1

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 8:07am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/1 "2021-11-20T08:07:47Z")

</div>

What I want to do is this:  
I have a time column, if a person changes info about a restaurant the time of change and the person that changes is added.  
I want to make recent changes clear with the word CHANGED.  
So I thought to use an If This Then That column  
If DATE is within now and X days ago, then CHANGED, else empty.  
How can I add dates other than TODAY in IFTTT?

 ![CleanShot 2021-11-20 at 09.02.39@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/42b4cfff79955568de2efc41ed0c196d0ee9f98d.png)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 20, 2021, 8:32am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/2 "2021-11-20T08:32:39Z")

</div>

I think you can add a math column to calculate how many days it has been since the change (relative to your “X”). Then:

If “days since change” is less than or equal to X then CHANGED, else empty.

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 8:36am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/3 "2021-11-20T08:36:22Z")

</div>

Mmm thanks, but doing math with date and time doesnt feel like an easy thing too 😉  
I will see where I end up! Thanks.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 20, 2021, 9:05am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/4 "2021-11-20T09:05:57Z")

</div>

It’s actually really, really simple…

Let’s say you want to highlight anything that’s changed in the past 7 days.

- Math column using the formula `Now-7`
- If-then-else column:  
– If Change Date is on or after math column, then CHANGED

And that’s it 🙂

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 9:54am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/5 "2021-11-20T09:54:06Z")

</div>

that feels doable!

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 10:37am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/6 "2021-11-20T10:37:36Z")

</div>

Question,  
If I do NOW-7 in a match column, it wants me to replace NOW with data from a column. But is shouldnt be like that, should it?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 20, 2021, 10:50am UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/7 "2021-11-20T10:50:57Z")

</div>

![Screen Shot 2021-11-20 at 6.50.01 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0b8ead596f43636f619d66a358d36d1aa4f46761.png)

---

<div class="post-metadata">

### Author: ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 20, 2021, 12:14pm UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/8 "2021-11-20T12:14:05Z")

</div>

Hola!

Funny, when I read the **IFTTT** word here I thought: WTF… what does IFTTT service have to do with a dates logic? 🤣

For me, IFTTT is this: [https://ifttt.com](https://ifttt.com) and the Glide component for this kind of logic is ITE.

Have a nice weekend!

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 12:45pm UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/9 "2021-11-20T12:45:42Z")

</div>

Ah thanks so much!

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 12:46pm UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/10 "2021-11-20T12:46:03Z")

</div>

To me its different names for the same idea 😉

---

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [November 20, 2021, 5:04pm UTC](https://community.glideapps.com/t/how-can-i-add-dates-other-than-today-in-ifttt/34805/11 "2021-11-20T17:04:57Z")

</div>

All working fine now! Thanks again!
