# The difference between two dates

**URL:** <https://community.glideapps.com/t/the-difference-between-two-dates/40376>\
**Category:** Ask for Help\
**Created:** [April 3, 2022, 10:11pm UTC](https://community.glideapps.com/t/the-difference-between-two-dates/40376 "2022-04-03T22:11:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\
**Post date:** [April 3, 2022, 10:11pm UTC](https://community.glideapps.com/t/the-difference-between-two-dates/40376/1 "2022-04-03T22:11:08Z")

</div>

Can I find the difference between two dates?

I have two columns, the first has the date of subscription and the other is the date of maintenance  
I need to know how many days are between the two dates

any ideas?

---

<div class="post-metadata">

**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\
**Post date:** [April 3, 2022, 11:02pm UTC](https://community.glideapps.com/t/the-difference-between-two-dates/40376/2 "2022-04-03T23:02:40Z")

</div>

Here is what I used in one of my apps and mentioned in another community post:

> What I did is used a template column because I was bringing the value in from another table and the calc didn’t like the rollup. So, did a template column of the rollup with shows in time format and this did a math column using this formula FLOOR(T/60) / 60. This gives you the value in hours, so 1 hour, 30 mins would be 1.5 hours.

---

<div class="post-metadata">

**Author:** ![Sales\_Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sales_manager/32/16172_2.png) [@Sales\_Manager](https://community.glideapps.com/u/Sales_Manager)\
**Post date:** [April 3, 2022, 11:23pm UTC](https://community.glideapps.com/t/the-difference-between-two-dates/40376/3 "2022-04-03T23:23:52Z")

</div>

thanks. but I think that’s not what I meant…  
for example:  
The first date is (March 3, 2022) and the second date is (March 25, 2022)  
I need to get the difference between the date ( 22 days)

---

<div class="post-metadata">

**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:** [April 4, 2022, 12:22am UTC](https://community.glideapps.com/t/the-difference-between-two-dates/40376/4 "2022-04-04T00:22:51Z")

</div>

Use a math column.

 ![Screen Shot 2022-04-04 at 8.22.17 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7c9a0ab559034e11ebca69941ce6cecef4c41f2a.png)