# Within today doesn’t work for a few hours each day

**URL:** <https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764>\
**Category:** Ask for Help\
**Created:** [January 19, 2024, 9:11pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764 "2024-01-19T21:11:13Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)\
**Post date:** [January 19, 2024, 9:11pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/1 "2024-01-19T21:11:13Z")

</div>

Hello!

In my app I use a few calculations and filters using “within Today”. I have a list of bookings for today that is filtered to show only today’s booking, and I also have two rollups to calculate the revenue today and the amount of guests. At a certain point every night or early morning these calculations stop working and I get blank lists and rollups are 0. At around 10 am the calculations start working again without any intervention.

My VPN is off. The booking date and time column is not set by time zone.

Any advice is appreciated

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 19, 2024, 10:04pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/2 "2024-01-19T22:04:33Z")

</div>

> [@Date is within today](https://community.glideapps.com/t/date-is-within-today/69744/3):
>
> Yes, this is a known bug. I submitted a ticket on this a couple weeks ago. Glide is working on a solution.

---

<div class="post-metadata">

**Author:** ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)\
**Post date:** [January 19, 2024, 10:26pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/3 "2024-01-19T22:26:32Z")

</div>

Thank you @Robert_Petitto , any workarounds?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 19, 2024, 10:42pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/4 "2024-01-19T22:42:41Z")

</div>

Convert all dates to a numeric value and then compare if they’re equal.  
I use the formula:  
`year(date)*10000+month(date)*100+day(date)`

---

<div class="post-metadata">

**Author:** ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)\
**Post date:** [January 20, 2024, 12:29am UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/5 "2024-01-20T00:29:04Z")

</div>

Much appreciated 🙏

---

<div class="post-metadata">

**Author:** ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)\
**Post date:** [January 26, 2024, 10:52pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/6 "2024-01-26T22:52:40Z")

</div>

FYI this bug seems to be fixed now

---

<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:** [January 26, 2024, 11:40pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/7 "2024-01-26T23:40:26Z")

</div>

That’s big. Thank you for updating.

---

<div class="post-metadata">

**Author:** ![GodRobot2024](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/godrobot2024/32/69574_2.png) [@GodRobot2024](https://community.glideapps.com/u/GodRobot2024)\
**Post date:** [January 26, 2024, 11:54pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/8 "2024-01-26T23:54:10Z")

</div>

Literally fixed today because many features on my apps started working as they should

---

<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 2, 2024, 11:54pm UTC](https://community.glideapps.com/t/within-today-doesn-t-work-for-a-few-hours-each-day/69764/9 "2024-02-02T23:54:41Z")

</div>

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