cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
awalker
Helper IV
Helper IV

Making option visible only during month of July

There is a selection in the app that should only be visible during the month of July of any year. 

I'm having trouble with the IF() function on this one. 

 

If(Toady() < DateValue(08/01) AND Toady() > DateValue(07/01), true, false)

 

Something like that. Figuring out the formatting of the "DaveValue" part is troublesome. Not much online that I could find either.

 

Any help is appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User II
Super User II

@awalker 

No need for an If. Using

Month(Today())=7 as the visible property of your button 

will resolve to either true or false.

View solution in original post

4 REPLIES 4
zmorek
Power Participant
Power Participant

Date(2021,08,01)

Year, Month, Day

@zmorek Sorry - I don't understand.

 

The button in question should only be visible for the month of July in any year. So every July 1st visible should go "true" and every July 31st visible should go "false".

 

I need help with the "IF" formula for that. 

 

Greetings

Drrickryp
Super User II
Super User II

@awalker 

No need for an If. Using

Month(Today())=7 as the visible property of your button 

will resolve to either true or false.

View solution in original post

awalker
Helper IV
Helper IV

Ah - now it clicks. Thanks!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,940)