# Automatic date operations

**URL:** <https://community.glideapps.com/t/automatic-date-operations/25379>\
**Category:** Ask for Help\
**Created:** [April 10, 2021, 9:58am UTC](https://community.glideapps.com/t/automatic-date-operations/25379 "2021-04-10T09:58:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\
**Post date:** [April 10, 2021, 9:58am UTC](https://community.glideapps.com/t/automatic-date-operations/25379/1 "2021-04-10T09:58:11Z")

</div>

Ok so, I need to make date connected operations, like showing how distant is a certain date from today, I can do it no problem,

BUT

to set a column to the today’s date, I need a user to trigger an action that will set the “today”'s column to today’s value.

Am I missing an automated way of doin it?

---

<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:** [April 10, 2021, 10:03am UTC](https://community.glideapps.com/t/automatic-date-operations/25379/2 "2021-04-10T10:03:54Z")

</div>

> [@MaxB](#):
>
> to set a column to the today’s date, I need a user to trigger an action that will set the “today”'s column to today’s value.

Can you explain more about the logic of this flow in your app’s context? You’re understanding it right, there needs to be a user-triggered action to do a set column.

---

<div class="post-metadata">

**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\
**Post date:** [April 10, 2021, 10:06am UTC](https://community.glideapps.com/t/automatic-date-operations/25379/3 "2021-04-10T10:06:16Z")

</div>

I calculate and show how many days are between today and th expiry dates of products, but to calculate it I need to know what day is today, nad to let glide know it i have to write it in a column, can’t glide get the date on it’s own?

---

<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:** [April 10, 2021, 10:38am UTC](https://community.glideapps.com/t/automatic-date-operations/25379/4 "2021-04-10T10:38:28Z")

</div>

You can point a value to “now” inside a math column.

---

<div class="post-metadata">

**Author:** ![MaxB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxb/32/15623_2.png) [@MaxB](https://community.glideapps.com/u/MaxB)\
**Post date:** [April 10, 2021, 12:40pm UTC](https://community.glideapps.com/t/automatic-date-operations/25379/5 "2021-04-10T12:40:42Z")

</div>

Never saw that, thanks.

This should solve all my problems, much love.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/automatic-date-operations/25379/6 "2024-01-17T16:52:41Z")

</div>