# Showing a special component between 2 dates (past and future)

**URL:** <https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318>\
**Category:** Ask for Help\
**Created:** [September 12, 2024, 12:51pm UTC](https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318 "2024-09-12T12:51:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib)\
**Post date:** [September 12, 2024, 12:51pm UTC](https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318/1 "2024-09-12T12:51:12Z")

</div>

Hi,  
I have 2 date columns to publish some news : “Start date” and “End date”.  
In grey or white : past items (no display)  
In yellow : items are displaying  
In red : future items (no display)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/057408267bbdbbba160b277310c02b9212a6b91e.png)

Here is the configuration  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/7/07bf84bde2a8c0ac5d4ecef19081bcaedcffe5f6.png)

The problem :  
When the “End Date” pasted today, the items disapear and a message “No more news” is displaying (that’s ok)  
BUT  
When I program a new row with a future date (in red)  
AND  
there are active items (in yellow) the message “No more news” is still displaying. (That’s because the system takes the last row to show the component).

How can I solve that ?

---

<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:** [September 12, 2024, 12:58pm UTC](https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318/2 "2024-09-12T12:58:51Z")

</div>

Try this:

- Create an if-then-else column as follows:  
– If Start Date is after Today, then `null` (leave empty)  
– If End Date is before Today, then `null`  
– Else `true`
- Then create a rollup column, target it at the if-then-else column and select “Count true”
- Then change your visibility condition such that it only shows when the rollup is greater than zero.

---

<div class="post-metadata">

**Author:** ![Korbib](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/korbib/32/71813_2.png) [@Korbib](https://community.glideapps.com/u/Korbib)\
**Post date:** [September 12, 2024, 1:05pm UTC](https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318/3 "2024-09-12T13:05:43Z")

</div>

Ho yes, that’s it !!!

In my case it has to be equal to 0

Thanks a lot 🙏

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 19, 2024, 1:06pm UTC](https://community.glideapps.com/t/showing-a-special-component-between-2-dates-past-and-future/76318/4 "2024-09-19T13:06:03Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.