# Filter items created last month

**URL:** <https://forum.bubble.io/t/filter-items-created-last-month/264139>\
**Category:** Need help\
**Created:** [May 24, 2023, 1:11am UTC](https://forum.bubble.io/t/filter-items-created-last-month/264139 "2023-05-24T01:11:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anon19893928](https://avatars.discourse-cdn.com/v4/letter/a/b5ac83/32.png) [@anon19893928](https://forum.bubble.io/u/anon19893928)\
**Post date:** [May 24, 2023, 1:11am UTC](https://forum.bubble.io/t/filter-items-created-last-month/264139/1 "2023-05-24T01:11:09Z")

</div>

Hello everyone.

I am trying to filter by `Creation date` where it will always be the last month.

So if this month is march it filter all the items created in february. If in may should filter all the items created in april.

Then, this filter should always return the previous month.

How could I do this approach?

I have tried doing `current date/time extract month - item.creation date` but it does not work.  
🙂

---

<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:** [May 24, 2023, 1:41am UTC](https://forum.bubble.io/t/filter-items-created-last-month/264139/2 "2023-05-24T01:41:56Z")

</div>

Hi there, @anon19893928… to do what you described, the following constraints should do the trick.

`Creation date >= Current date/time:rounded down to month +(months): -1`

`Creation date < Current date/time:rounded down to month`

Hope this helps.

Best…  
Mike

---

<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:** [August 2, 2023, 1:11am UTC](https://forum.bubble.io/t/filter-items-created-last-month/264139/3 "2023-08-02T01:11:35Z")

</div>

Closed on August 2, 2023, 1:11am UTC

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