# Showing a Tab between two dates

**URL:** https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765
**Category:** Ask for Help
**Created:** [March 18, 2024, 3:13pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765 "2024-03-18T15:13:17Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)
#### Post date: [March 18, 2024, 3:13pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/1 "2024-03-18T15:13:17Z")

</div>

What is the best approach to show a tab only, i.e. between May 1 and June 1 of each year.

Thanks

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 18, 2024, 3:18pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/2 "2024-03-18T15:18:47Z")

</div>

Make sure the dates are within the user profile table, or use some other logic, such as single value columns, to retrieve those dates from elsewhere and make them show up in the user table. Then add the appropriate tab visibility conditions comparing those dates to Today.

---

<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 18, 2024, 3:29pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/3 "2024-03-18T15:29:42Z")

</div>

I have a slightly different interpretation of your question than Jeff, so this may or may not be what you are looking for:

- Create a Math column in your User Profile table to get the month number of the current date: `Month(Now)`
- Use that column as a visibility condition on your tab - only show it when the Month Number equals 5

That would make the tab visible only for the month of May.

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 18, 2024, 3:34pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/4 "2024-03-18T15:34:10Z")

</div>

Well that’s a lot easier.

---

<div class="post-metadata">

### Author: ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)
#### Post date: [March 18, 2024, 3:38pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/5 "2024-03-18T15:38:08Z")

</div>

Is it possible to use from 05/01 to 06/01?

---

<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 18, 2024, 3:43pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/6 "2024-03-18T15:43:51Z")

</div>

Just to be clear, it needs to be visible on the 1st of June, but not on the 2nd of June - yes?

---

<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 18, 2024, 3:51pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/7 "2024-03-18T15:51:55Z")

</div>

> [@Benjamin\_Strickland](#):
>
> Is it possible to use from 05/01 to 06/01?

To make a tab visible between those two dates (inclusive), you need an extra column:

- First, a Math column:

```auto
Month(Now)*100
+Day(Now)

```

- Secondly, an if-then-else column:  
– If Math column is less than 501, then null (empty)  
– If Math column is greater than 601, then null (empty)  
– Else true
- Then use the if-then-else column in a tab visibility condition (only show the tab when it is checked)

---

<div class="post-metadata">

### Author: ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)
#### Post date: [March 18, 2024, 3:53pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/8 "2024-03-18T15:53:15Z")

</div>

Darren’s suggestion worked for me. Thank you.

---

<div class="post-metadata">

### Author: ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)
#### Post date: [March 18, 2024, 4:08pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/9 "2024-03-18T16:08:10Z")

</div>

Thanks

---

<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: [March 25, 2024, 4:08pm UTC](https://community.glideapps.com/t/showing-a-tab-between-two-dates/71765/10 "2024-03-25T16:08:14Z")

</div>

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