# Creating a Number of Days Since activation column **URL:** \ **Category:** Ask for Help\ **Created:** [June 21, 2025, 3:33pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652 "2025-06-21T15:33:52Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Andre75](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andre75/32/83970_2.png) [@Andre75](https://community.glideapps.com/u/Andre75)\ **Post date:** [June 21, 2025, 3:33pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/1 "2025-06-21T15:33:52Z")
Hi Everyone, 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 in advance for your help. ---
**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\ **Post date:** [June 21, 2025, 3:48pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/2 "2025-06-21T15:48:12Z")
Try using the Date Diffrence column ---
**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 21, 2025, 3:53pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/3 "2025-06-21T15:53:55Z")
> [@Andre75](#): > > ROUND(NOW - DateColumn) Can you show the full configuration for the math column? This should work. ---
**Author:** ![Andre75](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andre75/32/83970_2.png) [@Andre75](https://community.glideapps.com/u/Andre75)\ **Post date:** [June 21, 2025, 4:29pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/4 "2025-06-21T16:29:03Z")
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?? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/2/724f79f9303a48ace8153d2da5444a0539876fd3.png) ![Screenshot 2025-06-21 172645](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4de6e0e391cf7f35c21bd8bc49319bfce368262.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 21, 2025, 5:03pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/5 "2025-06-21T17:03:24Z")
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? ---
**Author:** ![Andre75](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andre75/32/83970_2.png) [@Andre75](https://community.glideapps.com/u/Andre75)\ **Post date:** [June 21, 2025, 5:17pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/6 "2025-06-21T17:17:29Z")
You’re right. I had some other fields coming in. I achieved result with a biot of code, probably Over the Top ! 🙂 ![image.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/5612228941dc81c2a8233f7f3e9d9c8cb18c9d25.png) ---
**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 21, 2025, 5:51pm UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/7 "2025-06-21T17:51:08Z")
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. ![1000005406](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad62db549f1de7af3a2423cbdb22670cb70c1615.png) ---
**Author:** ![Andre75](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andre75/32/83970_2.png) [@Andre75](https://community.glideapps.com/u/Andre75)\ **Post date:** [June 22, 2025, 11:08am UTC](https://community.glideapps.com/t/creating-a-number-of-days-since-activation-column/82652/8 "2025-06-22T11:08:08Z")
Jeff, thank you. Couldn’t see the wood for the trees!