# Date difference

**URL:** <https://community.glideapps.com/t/date-difference/80524>\
**Category:** Ask for Help\
**Created:** [March 5, 2025, 9:29pm UTC](https://community.glideapps.com/t/date-difference/80524 "2025-03-05T21:29:31Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [March 6, 2025, 11:54pm UTC](https://community.glideapps.com/t/date-difference/80524/7 "2025-03-06T23:54:23Z")

</div>

So the TRUNC math column solution in the other thread works?

> [@Extracting from an array](https://community.glideapps.com/t/extracting-from-an-array/80500/8):
>
> Ok here’s my proposed solution. From the array, use this to get the array length. Use this to calculate the date difference between the start date and now: TRUNC(N-D) Use this to calculate the index of the “current day”: MAX(MOD(D,C),0) And finally this to get the number of the day via the index.

---

_[View the full topic](https://community.glideapps.com/t/date-difference/80524)._