# Show only past 7 days in drop down selection

**URL:** <https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639>\
**Category:** Need help\
**Created:** [November 15, 2022, 3:03pm UTC](https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639 "2022-11-15T15:03:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcor123](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@dcor123](https://forum.bubble.io/u/dcor123)\
**Post date:** [November 15, 2022, 3:03pm UTC](https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639/1 "2022-11-15T15:03:54Z")

</div>

![Screenshot 2022-11-15 at 14.31.54](https://us1.discourse-cdn.com/bubble/original/3X/b/8/b8277b1e1ec8ff5dfc453d8360fb3dd7fcbfce99.png)  
Hi  
 ![Screenshot 2022-11-15 at 15.04.46](https://us1.discourse-cdn.com/bubble/original/3X/6/6/6621a69ce1fb8f90c58a69f255012f7acf77ae5d.png)

I saw this post ’ [How do I create a repeating group that only shows things with dates in the past 14 days?](http://forum.bubble.io/t/how-do-i-create-a-repeating-group-that-only-shows-things-with-dates-in-the-past-14-days/91813)’  
and i tried the expression but it did not work for me.

I have a repeating group filtered by a drop down however I cannot get it to resolve to only show data for the past seven days. When I input the expression Current date/time +(days): -7, the screen goes black (no data in the repeating group). Please see attached screenshot. Ideally I want the drop down to only allow 7 days which can be selected from to filter the repeating group.

Thanks

---

<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:** [November 15, 2022, 3:20pm UTC](https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639/2 "2022-11-15T15:20:48Z")

</div>

`date ≥ current date/time +(days): -7`

(you _might_ want to round the current date/time down to day first, depending on exactly what data you want to see)…

Also, again depending on what kind of data it is, you might need a second constraint so as not to show items who’s date is in the future.

`date < current date/time`

---

<div class="post-metadata">

**Author:** ![dcor123](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@dcor123](https://forum.bubble.io/u/dcor123)\
**Post date:** [November 15, 2022, 3:21pm UTC](https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639/3 "2022-11-15T15:21:52Z")

</div>

Thanks Adam!

---

<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:** [January 24, 2023, 3:04pm UTC](https://forum.bubble.io/t/show-only-past-7-days-in-drop-down-selection/232639/4 "2023-01-24T15:04:47Z")

</div>

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