# Today's column in glide table

**URL:** <https://community.glideapps.com/t/todays-column-in-glide-table/16560>\
**Category:** Ask for Help\
**Created:** [September 30, 2020, 11:15am UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560 "2020-09-30T11:15:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [September 30, 2020, 11:15am UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/1 "2020-09-30T11:15:00Z")

</div>

Hi gliders,

How would you create a “Today” in glide table. I want to build an app that is solely built in glide table and can’t find a way to create a column that will show today’s date across all rows.

Any ideas? 🤦🏻‍♂️

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2020, 11:59am UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/2 "2020-09-30T11:59:32Z")

</div>

Create a math column and set it to Now.

---

<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:** [September 30, 2020, 12:33pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/3 "2020-09-30T12:33:41Z")

</div>

Indeed! One of the best features of the year! Been asking for _months_.

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [September 30, 2020, 12:58pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/4 "2020-09-30T12:58:52Z")

</div>

Guess I’ve missed it.

Just write now?

---

<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:** [September 30, 2020, 1:03pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/5 "2020-09-30T13:03:06Z")

</div>

No, select it. It’s a new math column feature.

> [@new Date-time Math](https://community.glideapps.com/t/date-time-math/15963):
>
> The Math column can now do math with date/times. In particular: Subtracting two date/times produces a duration, which is a number and is measured in days, like in Google Sheets. Adding a duration (number) to a date/time, or subtracting it from a date/time will add/subtract that many days to it. You can pick “Now” as a substitution for a variable.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2020, 1:17pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/6 "2020-09-30T13:17:34Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/f5f6b93c6e96fd5cda913191e94b7ba326ea6115.png)

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [September 30, 2020, 1:35pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/7 "2020-09-30T13:35:54Z")

</div>

Worked perfectly. Thank both.

Now I have something wiered, I’m doing roll-up over relation to sum days, hours and min.

The hours and min are result of the days which is math between 2 dates.

The roll-up don’t allow me to sum the days but works perfect for the hours and min which as I said both are result of the days calc. (i.e days divided by 24to get hours and hours decided by 60 to get min)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2020, 2:13pm UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/8 "2020-09-30T14:13:04Z")

</div>

Would a template over the days calc allow you to do a rollup?

---

<div class="post-metadata">

**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\
**Post date:** [October 1, 2020, 6:54am UTC](https://community.glideapps.com/t/todays-column-in-glide-table/16560/9 "2020-10-01T06:54:32Z")

</div>

Didn’t do it for some reason but not critical for the app itself, just weird
