I’m working on a Glide app and need some help with creating a column that calculates the number of days since a specific setup date (stored in a “generated day” column).
My goal is to have this “number of days” column update dynamically each day, increasing by one as time passes. Essentially, I want to show how many days have elapsed since the initial setup date.
I’ve tried using a Math column with formulas like ROUND(NOW - DateColumn), but it seems I might be using the wrong approach or syntax.
Could anyone offer guidance on the correct way to achieve this in Glide? Are there specific column types, formulas, or methods I should be using to make this column dynamic and accurately calculate the days elapsed?
Any examples or explanations would be greatly appreciated!
Thanks for responses… The column I am working from is StartDate and I created it using an AI cell to extract date from a messy string in the original GeneratedDate column. Is the issue obvious to you? Perhaps my date string format is wrong??
What type of column is LT1Known?
From your screenshot, it looks like a Boolean type.
Shouldn’t you just be using the current date/time as a replacement there?
Why the JavaScript? All you needed to change in your math column is to replace NOW with Now instead of some random boolean value. A boolean is not a date and that’s why it failed. Now is a date and can be used with date math.
