# How to Perform \<= Checks on Dates?

**URL:** <https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744>\
**Category:** Questions\
**Created:** [January 23, 2025, 6:03am UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744 "2025-01-23T06:03:31Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nilsobrien](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/nilsobrien/32/237072_2.png) [@nilsobrien](https://forum.bubble.io/u/nilsobrien)\
**Post date:** [January 23, 2025, 6:03am UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744/1 "2025-01-23T06:03:31Z")

</div>

I have to be missing something fundamental… I simply want to check if a date in my database is ‘less-than-or-equal’ to the current date. However, I’m running into the following limitations

I cannot use `:rounded down to day` for `Current date/time`.  
I don’t have `<=` or an `is` operator for dates.

Been stuck on this silly item for \> 2 hours (even stumped ChatGPT 😉 and have to believe I am simply not understanding something basic.

How can I check to see if a date is \<= the current date?

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/5/5/555b230874b3930d54897af75638b4f3c38f3b6d.png)

---

<div class="post-metadata">

**Author:** ![DjackLowCode](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/djacklowcode/32/222536_2.png) [@DjackLowCode](https://forum.bubble.io/u/DjackLowCode)\
**Post date:** [January 23, 2025, 7:37am UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744/2 "2025-01-23T07:37:18Z")

</div>

@nilsobrien

\<current date + 1min? 😉

Remember that a bubble date is just a timestamp that gets rendered differently (as 8:00am for example) depending on what Timezone you’re in (although current date/time is the same for everyone).

Something to keep in mind with searches/constraints

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [January 23, 2025, 8:06am UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744/3 "2025-01-23T08:06:40Z")

</div>

Yeah… it’s a bizarre and annoying omission….

You have `=`, `<=`, and `>=` for dates in search constraints and filters…

But _not_ in conditions (no idea why, seems to be an arbitrary design choice by Bubble).

But the easiest, and most accurate way to do it is just to convert the dates to numbers by extracting the Unix timestamps.

i.e.

`date1: extract unix <= date2: extract unix`

---

<div class="post-metadata">

**Author:** ![grgrsmth](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/grgrsmth/32/149156_2.png) [@grgrsmth](https://forum.bubble.io/u/grgrsmth)\
**Post date:** [January 24, 2025, 6:31pm UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744/4 "2025-01-24T18:31:57Z")

</div>

I also find this omission frustrating so I’ve put [a request on the Bubble Ideaboard](https://bubble.io/ideaboard?idea=1737743443761x291183522292432900) to get it resolved.

---

<div class="post-metadata">

**Author:** ![nilsobrien](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/nilsobrien/32/237072_2.png) [@nilsobrien](https://forum.bubble.io/u/nilsobrien)\
**Post date:** [January 25, 2025, 4:43am UTC](https://forum.bubble.io/t/how-to-perform-checks-on-dates/356744/5 "2025-01-25T04:43:04Z")

</div>

Thank you the expert understanding of this speedbump! It was very frustrating to know what needed to be done, to see the platform had the capability, and to only be denied the ability because the UI blocks the capability.