# Glide table issue with "today" function **URL:** \ **Category:** Ask for Help\ **Created:** [July 27, 2022, 4:47am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306 "2022-07-27T04:47:48Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Mingtao\_Qi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mingtao_qi/32/38548_2.png) [@Mingtao\_Qi](https://community.glideapps.com/u/Mingtao_Qi)\ **Post date:** [July 27, 2022, 4:47am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/1 "2022-07-27T04:47:48Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 27, 2022, 4:55am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/2 "2022-07-27T04:55:02Z")
Use a [Math](https://docs.glideapps.com/all/topics/computed-columns/primary/math-column#date-and-time-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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/5791598f449ebee886b3ebf12b16f05d804a3dc4.png) ---
**Author:** ![Mingtao\_Qi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mingtao_qi/32/38548_2.png) [@Mingtao\_Qi](https://community.glideapps.com/u/Mingtao_Qi)\ **Post date:** [July 27, 2022, 6:16am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/3 "2022-07-27T06:16:55Z")
Thank you. Will give it a try. ---
**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:** [July 28, 2022, 1:27am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/4 "2022-07-28T01:27:14Z")
> [@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? ---
**Author:** ![Mingtao\_Qi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mingtao_qi/32/38548_2.png) [@Mingtao\_Qi](https://community.glideapps.com/u/Mingtao_Qi)\ **Post date:** [July 28, 2022, 3:15pm UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/5 "2022-07-28T15:15:03Z")
Thank you , it worked! ---
**Author:** ![Mingtao\_Qi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mingtao_qi/32/38548_2.png) [@Mingtao\_Qi](https://community.glideapps.com/u/Mingtao_Qi)\ **Post date:** [July 28, 2022, 3:15pm UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/6 "2022-07-28T15:15:35Z")
date column. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 28, 2022, 3:54pm UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/7 "2022-07-28T15:54:18Z")
If you’d like to learn more about the behaviour that you observed, have a read of the following: > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > 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. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… ---
**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:** [July 29, 2022, 12:08am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/8 "2022-07-29T00:08:08Z")
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. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 30, 2022, 12:08am UTC](https://community.glideapps.com/t/glide-table-issue-with-today-function/45306/9 "2022-07-30T00:08:09Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.