# Date calculation and comparisons

**URL:** <https://community.glideapps.com/t/date-calculation-and-comparisons/70693>\
**Category:** Ask for Help\
**Created:** [February 10, 2024, 7:16pm UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693 "2024-02-10T19:16:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 10, 2024, 7:16pm UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693/1 "2024-02-10T19:16:11Z")

</div>

Not sure if there is already a guide to this.

Formula Durations = (now -createdDate)/60  
Response is 02:30:05

i.e 2 hours, 30mins and 05 seconds

I want to use a comparison operator in the filterUI to show a record if Duration \> (60mins)

How do I do this ? Seems like I need to do some conversion somewhere but I can’t figure it out.

---

<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:** [February 11, 2024, 12:04am UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693/2 "2024-02-11T00:04:41Z")

</div>

So do you mean you need to convert that duration to minutes, and compare it to 60 mins?

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 11, 2024, 2:28am UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693/3 "2024-02-11T02:28:21Z")

</div>

yes please.

---

<div class="post-metadata">

**Author:** ![Dan\_San](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dan_san/32/24085_2.png) [@Dan\_San](https://community.glideapps.com/u/Dan_San)\
**Post date:** [February 11, 2024, 2:37am UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693/4 "2024-02-11T02:37:39Z")

</div>

found another post

round((now - creat)\*24,2)\*60

Thanks for all help

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 18, 2024, 2:38am UTC](https://community.glideapps.com/t/date-calculation-and-comparisons/70693/5 "2024-02-18T02:38:03Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.