cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ewoud
Helper III
Helper III

Datepicker only last day of the month

Hi there,

 

Is it possible to restrict a date picker to only be able to pick the last day of every month?

1 ACCEPTED SOLUTION

Accepted Solutions
Ewoud
Helper III
Helper III

I have been able (with a little help) to solve it with a collection. In the collection in the OnStart Property the collection shows every month with the last day of each month. Then on the Update property of the date field I added a formula that looks at the collection and then resets the date picked to the last day of that month.

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @Ewoud ,

There is no property on a date picker that changes the days displayed, but you could hard-code the OnChange event to only accept the last of each month (if it is not, reset the control).

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Digital
Skilled Sharer
Skilled Sharer

Unfortunately there is no easy way to restrict dates in the date picker. There are idea threads about this.

 

There are a number of date picker components you can install that are more flexible in terms of selecting dates ranges and restricting dates.

Ewoud
Helper III
Helper III

I have been able (with a little help) to solve it with a collection. In the collection in the OnStart Property the collection shows every month with the last day of each month. Then on the Update property of the date field I added a formula that looks at the collection and then resets the date picked to the last day of that month.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Top Kudoed Authors
Users online (2,349)