# Finding date in a Range

**URL:** <https://community.glideapps.com/t/finding-date-in-a-range/42740>\
**Category:** Ask for Help\
**Created:** [June 5, 2022, 12:57pm UTC](https://community.glideapps.com/t/finding-date-in-a-range/42740 "2022-06-05T12:57:43Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [June 5, 2022, 11:12pm UTC](https://community.glideapps.com/t/finding-date-in-a-range/42740/2 "2022-06-05T23:12:39Z")

</div>

> [@MattLB](#):
>
> Now I let Glide do all the work. I create a relation on a date (if it is a Date-only column it works, if it is a Date-Time column(like a meeting) I convert it using the Date Compute Column)

Gotta tell you that this is not reliable and might break with iOS. Nowadays I stay away from this, it caused me too much trouble in the past. Glide’s underlying date/time format combined with Luxon was not friendly for Safari, and it almost always returned “invalid” for me.

I would just convert it to a numerical column, I believe Bob had the same method in his video. I usually do YYYYMMDD so my formula is:

YEAR(D)\*10000 + MONTH(D) \* 100 + DAY(D)

With D being the timestamp in question.

---

_[View the full topic](https://community.glideapps.com/t/finding-date-in-a-range/42740)._