# Date conditions

**URL:** <https://community.glideapps.com/t/date-conditions/24960>\
**Category:** Ask for Help\
**Created:** [March 31, 2021, 7:38am UTC](https://community.glideapps.com/t/date-conditions/24960 "2021-03-31T07:38:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![smac](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@smac](https://community.glideapps.com/u/smac)\
**Post date:** [March 31, 2021, 7:38am UTC](https://community.glideapps.com/t/date-conditions/24960/1 "2021-03-31T07:38:25Z")

</div>

Hello,

Is there a way to show new members when they are added & display them in a section for let’s say for 7 days? I want to create a section that shows the newest members so our community can get to know them.

Thanks!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 31, 2021, 7:52am UTC](https://community.glideapps.com/t/date-conditions/24960/2 "2021-03-31T07:52:00Z")

</div>

Are you collecting the date that new members sign up and storing it in their profile?  
If not, you’ll need to do that - the easiest way is to do it as part of the onboarding process.  
Once you have that, then it’s simply a matter of presenting them as an Inline List, and then filter that by comparing the sign up date to the current date/time.

---

<div class="post-metadata">

**Author:** ![smac](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@smac](https://community.glideapps.com/u/smac)\
**Post date:** [March 31, 2021, 8:03am UTC](https://community.glideapps.com/t/date-conditions/24960/3 "2021-03-31T08:03:35Z")

</div>

Yes I am collecting the date, but how do I show it if I only want to show them on a list for a week as new members?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 31, 2021, 8:32am UTC](https://community.glideapps.com/t/date-conditions/24960/4 "2021-03-31T08:32:30Z")

</div>

Okay, so there are a few different ways you could do this. Here is one way…

- Assume you have a column in your Users sheet called “Join Date”
- Create a new Math column in that sheet, and use the formula `NOW-7`  
 ![Screen Shot 2021-03-31 at 4.30.19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/43bfb60a15f7af71fbd1f0149d4f4eae868acc91.png)
- That will give you the date one week ago
- You can then use that column as a filter with your Inline List, it will be something like `Join Date is on or after Last Week`

---

<div class="post-metadata">

**Author:** ![smac](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@smac](https://community.glideapps.com/u/smac)\
**Post date:** [April 1, 2021, 5:49am UTC](https://community.glideapps.com/t/date-conditions/24960/5 "2021-04-01T05:49:54Z")

</div>

Oh it worked, thank you!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 1, 2021, 6:05am UTC](https://community.glideapps.com/t/date-conditions/24960/6 "2021-04-01T06:05:04Z")

</div>

Nice job 👍