# Display different image based on how long since sign up

**URL:** <https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853>\
**Category:** Ask for Help\
**Created:** [October 5, 2024, 3:30pm UTC](https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853 "2024-10-05T15:30:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![izumiinoue](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izumiinoue/32/79768_2.png) [@izumiinoue](https://community.glideapps.com/u/izumiinoue)\
**Post date:** [October 5, 2024, 3:30pm UTC](https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853/1 "2024-10-05T15:30:25Z")

</div>

Is it possible to rotate between different images based on the number of weeks/months since a user has signed up? I’m already collecting the sign up date for each user in the **Users** table, how should I go about setting this up?

**For example:**

- Week 1 (\<7 days) since sign up, show image A
- Week 2 (7~14 days) since sign up, show image B
- Month 2 (30~60 days) since sign up, show image C

 ![Screenshot 2024-10-05 at 11.21.11 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a23d767b7ad237e7c5b54827d8d3bceadc82dfde.jpeg)  
For context, it’s meant to be a ‘Quote of the Week/Month’ section on my home page.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 6, 2024, 12:11am UTC](https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853/2 "2024-10-06T00:11:24Z")

</div>

- Create a Date Difference column with the start date being users’ Sign Up date, and the end date being “Now”.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4e6dab7920271bb00a4358fb3ea961588d4390a.png)

- Choose the appropriate number of days/weeks you need, and show/hide your images based on that number of days/weeks.

---

<div class="post-metadata">

**Author:** ![izumiinoue](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izumiinoue/32/79768_2.png) [@izumiinoue](https://community.glideapps.com/u/izumiinoue)\
**Post date:** [October 6, 2024, 6:09am UTC](https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853/3 "2024-10-06T06:09:37Z")

</div>

Thanks Thinh, I’ve set up the date difference column in my Users table.

But do you mind breaking down the 2nd part? What are the exact steps to show/hide the images (I have a separate table with the quote images uploaded)? Sorry, newbie here.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [October 6, 2024, 8:51am UTC](https://community.glideapps.com/t/display-different-image-based-on-how-long-since-sign-up/76853/4 "2024-10-06T08:51:32Z")

</div>

You can use the visibility conditions for the image component and show/hide it based on a User Profiles column value. Point it to the column where you calculate your date difference and adjust as needed.
