# Today value not working around midnight

**URL:** <https://community.glideapps.com/t/today-value-not-working-around-midnight/56487>\
**Category:** Report a Bug\
**Created:** [January 9, 2023, 1:23pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487 "2023-01-09T13:23:38Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [January 9, 2023, 1:23pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/1 "2023-01-09T13:23:38Z")

</div>

Hello team,

All in the title.  
The loom video will be better than my explanation…

Have a nice day all!

[Possible issue with today value](https://www.loom.com/share/809852bced084d8691a9a3e3745ae119)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 9, 2023, 2:44pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/2 "2023-01-09T14:44:05Z")

</div>

Bonjour Martin, là où je suis il est peu après 20h et les tests que j’ai fait sur une colonne ITE avec une DateTime et “within today” fonctionne bien.

Tu es certain que le souci apparaît aux alentours de minuit ?

Tu as essayé d’utiliser les autres comparatifs tels que “is on or before/after” pour voir si le souci aux alentours de minuit les affecte aussi ?

---

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [January 9, 2023, 4:06pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/3 "2023-01-09T16:06:39Z")

</div>

Bonjour Nathanael 🙂

Oui jai testé avec before/after, bien que pas present dans la video.

Le mieux, je réessaye ce soir ! je mets un rappel

Merci

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 9, 2023, 7:19pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/4 "2023-01-09T19:19:39Z")

</div>

Bonjour Martin, il est 00:40 où je suis et j’ai pensé à tester un peu avant et un peu après minuit. Le résultat est inattendu (peut-être normal mais je ne m’y attendait pas).

**Avant minuit**

 ![before-midnight](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b63f5e8ab6b69fe34795dedc106dc4ebe54381af.jpeg)

**Juste après minuit**

 ![just-after-midnight](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c48e846000ca4f27542c6caff0c84692d3898edc.jpeg)

**Bien après minuit**

 ![well-after-midnight](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/631723bca76fbecfcfc9ab202a8b9f0053bbd511.jpeg)

**Test des autres comparatifs**

 ![Screenshot 2023-01-10 at 00.43.11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/19255edba365bfd831c0e79c960fcde7f8a9933a.jpeg)

Surprenant de voir \< et ≤ donner le même résultat, ainsi que \> et ≥ .

**Dernier test**  
Dans une colonne Date, j’ai tapé “today” et “tomorrow”. Cela m’a donné le 9/1/23 et 10/1/23 respectivement, alors qu’ici je suis minuit passé donc le 10/1/23.

Je suis un peu surpris. Je vais me coucher en songeant au pourquoi du comment.

---

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [January 14, 2023, 5:02pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/5 "2023-01-14T17:02:57Z")

</div>

Salut Nathanael,

I checked… it’s not working between 00:00 and 01:00…  
(same as above)

😕 @SantiagoPerez

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 15, 2023, 2:43am UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/6 "2023-01-15T02:43:48Z")

</div>

At exactly 1:00, “is within today” becomes correct? So it is buggy only between 00:00 and 01:00?

@Mark

---

<div class="post-metadata">

**Author:** ![Martin\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martin_b/32/74360_2.png) [@Martin\_B](https://community.glideapps.com/u/Martin_B)\
**Post date:** [January 19, 2023, 11:12pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/7 "2023-01-19T23:12:05Z")

</div>

Here is a new test… weird.

@SantiagoPerez  
Picture says it all

 ![Screenshot 2023-01-20 at 00.13.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/e/ae5975fa73e2dd8c42610e3ae3f00ba516f07a7c.jpeg)

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [January 19, 2023, 11:19pm UTC](https://community.glideapps.com/t/today-value-not-working-around-midnight/56487/8 "2023-01-19T23:19:38Z")

</div>

Hi @Martin_B

Thanks for the information and the videos.

Do you mind submitting a support ticket? That way we can keep investigating further.