# "Not Within" Filter

**URL:** <https://community.glideapps.com/t/not-within-filter/12303>\
**Category:** Feature Requests\
**Created:** [July 11, 2020, 1:05pm UTC](https://community.glideapps.com/t/not-within-filter/12303 "2020-07-11T13:05:34Z")\
**Posts on this page:** 8\
**Page:** 1

<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:** [July 11, 2020, 1:05pm UTC](https://community.glideapps.com/t/not-within-filter/12303/1 "2020-07-11T13:05:35Z")

</div>

Hi @Mark,

Any chance we can get a **“Not within”** filter. I’d like to show a warning text if a date is not within the first date (same day).

 ![Screen Shot 2020-07-11 at 9.03.19 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/488510b8226cd5d472d914a666eda49844b442c5.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 11, 2020, 3:47pm UTC](https://community.glideapps.com/t/not-within-filter/12303/2 "2020-07-11T15:47:12Z")

</div>

Just thinking out loud here: The “not within” is less of a problem than the question of “within what?”. Ideally for those predicates you could specify a range, which could be

- start date/time to end date/time
- the minute/hour/day/week/month/year of some date/time
- within some number of minutes/hours/days/weeks/months/years of some date/time
- …?

---

<div class="post-metadata">

**Author:** ![Naos\_Wilbrink](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/naos_wilbrink/32/769_2.png) [@Naos\_Wilbrink](https://community.glideapps.com/u/Naos_Wilbrink)\
**Post date:** [July 11, 2020, 3:49pm UTC](https://community.glideapps.com/t/not-within-filter/12303/3 "2020-07-11T15:49:14Z")

</div>

> [@Mark](#):
>
> - start date/time to end date/time
> - the minute/hour/day/week/month/year of some date/time
> - within some number of minutes/hours/days/weeks/months/years of some date/time
> - …?

They are all relevant 🙂

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 11, 2020, 3:50pm UTC](https://community.glideapps.com/t/not-within-filter/12303/4 "2020-07-11T15:50:32Z")

</div>

I know 😉

---

<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:** [July 11, 2020, 4:01pm UTC](https://community.glideapps.com/t/not-within-filter/12303/5 "2020-07-11T16:01:07Z")

</div>

I love the way you think. I was just hoping for the day…“within \> Today” is the whole day, so “not within \> Date” would be anything that’s not the day of the date.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 30, 2020, 5:07pm UTC](https://community.glideapps.com/t/not-within-filter/12303/6 "2020-07-30T17:07:32Z")

</div>

“Not within” would also be helpful for me in an app I’m working on.

I’ve been using a “refresh” button in a free app to force a sheet reload to move to “today”. I’d like to assign visibility to my refresh button that checks if a column in my sheet — that contains a " today()" formula — is not within today. If it’s not, then show the refresh button. I don’t want the refresh button visible if the app is already displaying the correct date.

The other possibility would be to have visibility conditions based on the visibility of other components — so show the refresh button IF the other button is not visible (which is set to only be visible if “today” column is within today).

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 30, 2020, 5:29pm UTC](https://community.glideapps.com/t/not-within-filter/12303/7 "2020-07-30T17:29:14Z")

</div>

You could just set an if then column in the sheet if within today. Then set your visibility based on the if then column value.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [July 30, 2020, 5:42pm UTC](https://community.glideapps.com/t/not-within-filter/12303/8 "2020-07-30T17:42:28Z")

</div>

![giphy](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/8fa114c85663062f1c52122622d9a906bdfe3bbe.gif)

Good point!
