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 today’s date.
I’m wondering if there’s a way to get the today function to actually update automatically on a daily basis.
Use a Math column with the Now special value. This will always give you the current date/time (from the users device).
Thank you. Will give it a try.
Just curious, did you use TODAY in an Excel function column or did you type “today” into a date column?
Thank you , it worked!
date column.
If you’d like to learn more about the behaviour that you observed, have a read of the following:
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.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.