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? :man_facepalming:t2:

Create a math column and set it to Now.

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

Guess I’ve missed it. Just write now?

No, select it. It’s a new math column feature. [image] new Date-time Math Glide FAQs 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. [image] [image]

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)

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

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

Today's column in glide table

Ask for Help

Robert_Petitto September 30, 2020, 1:03pm 5

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

Topic		Replies	Views
🆕 Date-time Math General data-editor	123	14834	September 27, 2023
SUM of column data for each day Ask for Help	10	1179	March 9, 2022
How to pull in Current Date to column in Glide Table Ask for Help	2	125	August 23, 2025
🗓 Month, Day, and Year Math Functions Ask for Help	47	4115	July 15, 2023
🆕 Comparing Dates General	51	4776	January 14, 2022

Today's column in glide table

Related topics