Is there a way of showing this from a date within a sheet referencing today’s date?

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: [image] Glide Docs Welcome to Glide Docs, a stea…

Thanks Darren, I’ve got something working, but it will only show day count [Screen Shot 2021-06-01 at 8.44.09 PM] 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]

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…

I thought this was a nocode platform! :rofl:

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…

I just built this last night in fact: [image] ConnectPro · Glide

What’s with the whispering, everybody else still asleep in the Petitto household? :joy: :sleeping:

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]

The commenting feature in Glide has relative dates by default. This relative date construct in Glide allows you to have relative dates anywhere.

'3 days ago', 'a month ago' 'tomorrow'

Ask for Help

Jeff_Hager June 2, 2021, 3:29pm 15

Slightly unrelated, but this thread spurred this.

Topic		Replies	Views
Add more date formats and time-since calculations Feature Requests	6	2142	October 27, 2021
🆕 Comparing Dates General	51	4443	January 14, 2022
Date relative translation Ask for Help	18	781	December 8, 2021
If then else with DATE Ask for Help	28	3317	May 25, 2022
Format Days Countdown Ask for Help	3	439	January 3, 2023

'3 days ago', 'a month ago' 'tomorrow'

Related topics