Showing results for 
Search instead for 
Did you mean: 

Restrict available dates in Datepicker controls

Add MaxDate and MinDate properties to avoid selecting dates out of range. Examples:

Avoid selecting dates in the past:

Datepicker1.MinDate: Today()


Set maximum selectable date to 1 year in the future since today:

Datepicker1.MaxDate: DateAdd( Today(), 1, Years )


Attached image shows what it would look like MinDate property 🙂

Status: Under Review

Updating status and adding @FilipK

Helper V

@Digital: the semicolon is correct if you are in Europe.

@FlyitComPl: since recent you can also say If(Self.SelectedDate>Today();Reset(Self))

Frequent Visitor

My requirement is user able to select the past 18 years' date. 

Advocate I

I also want to prevent user from selecting dates in the future for expense reports.

Regular Visitor



It would be nice if we could set the DatePicker to show only month and year.



Continued Contributor

Ideally the date picker would be configurable in the following ways:


  • Select a date range
  • Select a start day of the week - Sunday US, Monday Europe
  • Ability to exclude dates e.g. dates in the past
  • Enable user to select a date or range without the need to click OK
  • Configure the appearance without the need to hack JSON in msapp or change the theme
Regular Visitor

So, it's been 2 years since this was posted. I am wondering if we have to wait another 2 years to update the status, and another 2 years to start working on this, and another 2 years to test it, and another 2 years to implement it. I will probably retire by then. 

Resolver I

Any updates on this?

Regular Visitor

Come on PowerApps team, please add this feature