Showing a Tab between two dates

Ask for Help
1

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

Thanks

2

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.

3

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.

3 Likes
4

Well that’s a lot easier.

2 Likes
5

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

6

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

1 Like
7

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

  • First, a Math column:
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)
1 Like
8

Darren’s suggestion worked for me. Thank you.

1 Like
9

Thanks

10

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