Excel has the “=today()” function which returns today’s date. This function updates the date when the day passes over. Glide seems to have the same function. However it only returns today’s date on the day the command is entered into the glide table cell. After that it never updates the date to tod…

Use a Math column with the Now special value. This will always give you the current date/time (from the users device). [Screen Shot 2022-07-27 at 12.57.47 PM]

[image] Mingtao_Qi: After that it never updates the date to today’s date. Just curious, did you use TODAY in an Excel function column or did you type “today” into a date column?

If you’d like to learn more about the behaviour that you observed, have a read of the following: [image] Fun with Dates Project Showcase I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum…

In short, Glide tries to convert your text into an equivalent in date/time, and it stays like that. It’s a shortcut to get dates into date columns and I find it super useful when doing testing. If you want a constantly updated “today” value, you can use Darren’s method.

Glide table issue with "today" function

Ask for Help

Darren_Murphy July 28, 2022, 3:54pm 7

If you’d like to learn more about the behaviour that you observed, have a read of the following:

Topic		Replies	Views
How to pull in Current Date to column in Glide Table Ask for Help	3	89	August 30, 2025
How can I display today's date on a screen e.g. "Today is Friday 9th August"? Ask for Help	7	111	August 14, 2024
How do you use the "today" item Ask for Help	17	476	June 17, 2022
Update Automatically Today Function Ask for Help	11	311	February 24, 2024
Today's column in glide table Ask for Help	8	1778	October 1, 2020

Glide table issue with "today" function

Related topics