# '3 days ago', 'a month ago' 'tomorrow' **URL:** \ **Category:** Ask for Help\ **Created:** [June 1, 2021, 7:57am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462 "2021-06-01T07:57:16Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [June 1, 2021, 7:57am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/1 "2021-06-01T07:57:16Z")
Is there a way of showing this from a date within a sheet referencing today’s date? ---
**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:** [June 1, 2021, 8:04am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/2 "2021-06-01T08:04:53Z")
In Glide yes, it’s trivial with Date math. - 3 days ago: `Now - 3` - tomorrow: `Now + 1` - a month ago: `Now - 30` (rough approximation - if you need _exactly_ one month, that’s possible but a slightly more complex formula required) Some references: > **[Glide Docs](https://www.glideapps.com/docs)** > > Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build! > [@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:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [June 1, 2021, 8:45am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/3 "2021-06-01T08:45:32Z")
Thanks Darren, I’ve got something working, but it will only show day count ![Screen Shot 2021-06-01 at 8.44.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a882ca063295fd40e9f6fde21870e779cb77a709.png) I’m looking for the reverse of what’s in this next image. you auto display natural language based on a date ![Screen Shot 2021-06-01 at 8.41.19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a15018842e10a9058c2a2bc7047d39e9b2f85f20.png) ---
**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:** [June 1, 2021, 8:51am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/4 "2021-06-01T08:51:23Z")
ah, I see. Well, that’s certainly possible. What I’d suggest is to start by defining all the rules, and then you can build the logic to fit into those rules. You’ll most likely need a combination of Math columns, Template columns and if-then-else columns. The logic could get quite hairy, depending on how far you want to take it. But it’s certainly doable. ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [June 1, 2021, 9:48am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/5 "2021-06-01T09:48:21Z")
I thought this was a nocode platform! 🤣 ---
**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:** [June 1, 2021, 10:32am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/6 "2021-06-01T10:32:50Z")
Zero code required, I can assure you of that. It’s probably not that bad, actually. Let’s just consider the case of dates in the past. Your “rules” might be something like: - Within 5 mins of now: “just now” - More than 5 mins ago, but less than one hour: “xx mins ago” - More than 1 hour ago, but less than 2 hours ago: “1 hour ago” - More than 2 hours ago, but less than 24 hours ago: “xx hours ago” - More than 24 hours ago, but less than 48 hours ago: “1 day ago/yesterday” - More than 2 days ago, but less than 7 days ago: “x days ago” - etc… - etc… To get the above, you’d need: - One math column for each of the time units (mins, hours, days, weeks…) - A template column for each of the above display options (which would use the appropriate math column as a replacement) - And then a single if-then-else column to determine which template column to use based on the calculated age That’s how I would approach it. But if you want to wait a couple of hours, our resident date/time wizard, aka Chuck Norris, aka @Jeff_Hager should be around, and he’ll show you how to do it with just one column 🤣 ---
**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:** [June 1, 2021, 11:40am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/7 "2021-06-01T11:40:59Z")
I just built this last night in fact: > **[ConnectPro · Glide](https://www.loom.com/share/4d4ab56b39064ec4b85c7db2faa35561)** ---
**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:** [June 1, 2021, 11:50am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/8 "2021-06-01T11:50:51Z")
What’s with the whispering, everybody else still asleep in the Petitto household? 😂 😴 ---
**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:** [June 1, 2021, 11:51am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/9 "2021-06-01T11:51:43Z")
They sure are 😉 ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [June 1, 2021, 11:40pm UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/10 "2021-06-01T23:40:08Z")
Adalo have a fairly elegant solution to this, i’m surprised more people don’t need this natural language ![Screen Shot 2021-06-02 at 11.38.57 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3120b3856da294d02997eade1aaa8726989c5b3.png) ---
**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:** [June 2, 2021, 2:02am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/11 "2021-06-02T02:02:40Z")
The commenting feature in Glide has relative dates by default. This relative date construct in Glide allows you to have relative dates anywhere. ---
**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:** [June 2, 2021, 2:04am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/12 "2021-06-02T02:04:33Z")
Sounds like a feature request to me - agreed it would be great to have “out of the box” 👍 ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [June 2, 2021, 4:55am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/13 "2021-06-02T04:55:28Z")
Ah interesting, thanks for pointing that out. Is that the only place it shows automatically? (I haven’t found a way to get a date data input to display like this). I’ll log a feature request. ---
**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:** [June 2, 2021, 12:59pm UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/14 "2021-06-02T12:59:55Z")
As far as I’m aware, yes (except for the chat tab). It would be nice to have as an option within a date/time & math columns @mark @jason ---
**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:** [June 2, 2021, 3:29pm UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/15 "2021-06-02T15:29:44Z")
Slightly unrelated, but this thread spurred this. > [@clock3 System/GMT Time - Solved!](https://community.glideapps.com/t/system-gmt-time-solved/27524): > > This is an extension of the request for [System Time, please](https://community.glideapps.com/t/system-time-please/26837). There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to… ---
**Author:** ![Rollo\_Wenlock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rollo_wenlock/32/26956_2.png) [@Rollo\_Wenlock](https://community.glideapps.com/u/Rollo_Wenlock)\ **Post date:** [November 6, 2021, 8:44am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/16 "2021-11-06T08:44:17Z")
The new updates within database creation now let’s you do all the time/date stuff out of the box - fantastic. ---
**Author:** ![Jireh\_Lee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jireh_lee/32/52727_2.png) [@Jireh\_Lee](https://community.glideapps.com/u/Jireh_Lee)\ **Post date:** [September 27, 2023, 7:55am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/17 "2023-09-27T07:55:11Z")
Is there a way to display the dates for comments component NOT in relative mode but to present the actual date itself? Is there a switch I can flip for this? ---
**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 27, 2023, 10:03am UTC](https://community.glideapps.com/t/3-days-ago-a-month-ago-tomorrow/27462/18 "2023-09-27T10:03:57Z")
I’ve asked Glide for this too. Not at the moment. Sounds like a good feature request 🙂