# Date "is on or before/after" only for Today?

**URL:** <https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471>\
**Category:** Ask for Help\
**Created:** [September 28, 2020, 9:39pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471 "2020-09-28T21:39:04Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 28, 2020, 9:39pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/1 "2020-09-28T21:39:04Z")

</div>

I’m trying to use the new **Event Picker** , but while it doesnt have a way to block days/hours, I need to check if the date-time i’m picking **is on or before** a date-time already scheduled

I don’t wanna create 2 columns if I can do it with one only…

@Mark is it normal?

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/ad61bec58549759d97f13fd946d1aba7491fc6a3.png)

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 28, 2020, 9:45pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/2 "2020-09-28T21:45:42Z")

</div>

Do you have another Date column in your table?

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 28, 2020, 9:50pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/3 "2020-09-28T21:50:07Z")

</div>

Yes, I’m picking **Start Date Agendar** in user table, and in this table in the pic, I have Start and End sheduled date-time

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ccfd6b18a351c67edc6729c28ec19081c26239ec.png)

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 28, 2020, 9:53pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/4 "2020-09-28T21:53:29Z")

</div>

And when I try with **is before** works too…

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d2940bedc01e9eaeebcd07a734c7f41497e32f75.png)

---

<div class="post-metadata">

**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\
**Post date:** [September 28, 2020, 10:07pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/5 "2020-09-28T22:07:30Z")

</div>

I have also wonder why this is done. I need also on or before - and not just “today”

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 28, 2020, 10:08pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/6 "2020-09-28T22:08:46Z")

</div>

I gotta complete this app for a client and I just have to set all the schedules up

---

<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:** [September 29, 2020, 8:39pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/7 "2020-09-29T20:39:45Z")

</div>

We’ll fix this, but I can’t give you a timeline yet.

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 29, 2020, 8:57pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/8 "2020-09-29T20:57:15Z")

</div>

Thanks @Mark

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 29, 2020, 9:09pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/9 "2020-09-29T21:09:15Z")

</div>

Btw, I’ve already set everything up! Take a look

> [@new Event Picker](https://community.glideapps.com/t/event-picker/15965/103):
>
> Now, with everything set up, it’s so smooth star_struck

---

<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:** [September 29, 2020, 10:29pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/10 "2020-09-29T22:29:40Z")

</div>

Does the “is within” work?

---

<div class="post-metadata">

**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\
**Post date:** [September 29, 2020, 10:31pm UTC](https://community.glideapps.com/t/date-is-on-or-before-after-only-for-today/16471/11 "2020-09-29T22:31:01Z")

</div>

No, this option also works only with Today

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/dbe94a7375a960d1727c7ecfba607575db18c7da.png)
