# How can I only search for data created yesterday?

**URL:** <https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419>\
**Category:** Need help\
**Created:** [November 29, 2023, 4:51pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419 "2023-11-29T16:51:12Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jona](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jona](https://forum.bubble.io/u/jona)\
**Post date:** [November 29, 2023, 4:51pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/1 "2023-11-29T16:51:12Z")

</div>

Hi forum,

I want to search “Leads” that are only created in the previous day.

 ![Schermafbeelding 2023-11-29 om 17.50.55](https://us1.discourse-cdn.com/bubble/original/3X/5/4/5446e6e7d70816bdbeb5d403d5e156a328cef1be.png)

How can I proceed this?

Thanks,

---

<div class="post-metadata">

**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\
**Post date:** [November 29, 2023, 4:54pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/2 "2023-11-29T16:54:55Z")

</div>

Hi there, @jona… try using these constraints.

`Created Date >= Current date/time:rounded down to date +(days): -1`  
`Created Date < Current date/time:rounded down to date`

Best…  
Mike

---

<div class="post-metadata">

**Author:** ![jona](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jona](https://forum.bubble.io/u/jona)\
**Post date:** [November 29, 2023, 5:02pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/3 "2023-11-29T17:02:04Z")

</div>

Thanks Mike, will this take the whole day from 00:00 to 00:00 the next day?

Thanks,

---

<div class="post-metadata">

**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\
**Post date:** [November 29, 2023, 5:03pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/4 "2023-11-29T17:03:49Z")

</div>

Yes, those constraints will give you the whole day for yesterday (i.e., always the day before the current day).

---

<div class="post-metadata">

**Author:** ![jona](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jona](https://forum.bubble.io/u/jona)\
**Post date:** [November 29, 2023, 5:05pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/5 "2023-11-29T17:05:26Z")

</div>

Okay, nice!

And a other question,  
 ![Schermafbeelding 2023-11-29 om 18.05.00](https://us1.discourse-cdn.com/bubble/original/3X/f/2/f2fdaa25c9babf3bc26f1d31a8e7a4b9c426654c.png)

How can I do the same thing here? So it is taking the date from yesterday.

---

<div class="post-metadata">

**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\
**Post date:** [November 29, 2023, 5:06pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/6 "2023-11-29T17:06:36Z")

</div>

If you are asking how to show yesterday’s date, use the current date/time +days -1.

---

<div class="post-metadata">

**Author:** ![jona](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jona](https://forum.bubble.io/u/jona)\
**Post date:** [November 29, 2023, 5:08pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/7 "2023-11-29T17:08:42Z")

</div>

![Schermafbeelding 2023-11-29 om 18.08.19](https://us1.discourse-cdn.com/bubble/original/3X/e/f/efdbc971afc1267ef30c255743dea436894528df.png)

Yes, but I want to format it at this way, and I dont see the option “+days”

---

<div class="post-metadata">

**Author:** ![mikeloc](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mikeloc/32/93001_2.png) [@mikeloc](https://forum.bubble.io/u/mikeloc)\
**Post date:** [November 29, 2023, 5:09pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/8 "2023-11-29T17:09:28Z")

</div>

You should see the _+days_ operator before adding the _formatted as_ operator to the expression.

---

<div class="post-metadata">

**Author:** ![jona](https://avatars.discourse-cdn.com/v4/letter/j/3d9bf3/32.png) [@jona](https://forum.bubble.io/u/jona)\
**Post date:** [November 29, 2023, 5:15pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/9 "2023-11-29T17:15:26Z")

</div>

Thanks, again Mike.

Worked!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [February 7, 2024, 4:52pm UTC](https://forum.bubble.io/t/how-can-i-only-search-for-data-created-yesterday/295419/10 "2024-02-07T16:52:07Z")

</div>

This topic was automatically closed after 70 days. New replies are no longer allowed.