If a 43-line formula can solve it, a native function certainly can.
Imagine you’ve just delivered a masterpiece: a sophisticated “Agency OS” for a high-value client. The relational architecture is flawless, the automations are put in place and the AI is elegantly structuring a mountain of messy intake data. It feels like the future of work.
Then your client looks at the “Project Tenure” column and sees: 1,508 days. In an instant, the high ceiling of your custom application hits a very low, very frustrating floor. Humans don’t experience time as a flat integer — we think in milestones: years, months, and weeks.
makers have been asking for a native way to express durations beyond days since October 2018. More than seven years later, it remains one of those foundational basics that — if left unaddressed — undercuts the polish of even the most carefully built doc.
What the Community Has Been Saying
Real makers with real use cases keep running into this wall. I brought a few together, maybe there are many more.
The original request dates back to 2018. Wesley D. asked for duration options beyond days — specifically years and months. Fourteen replies later, the thread was still active…
