Dropdown to force date picker range selectiom

(0) Share

Report

Posted on by a10703ant

It's possible to have a dropdown with year and month and force the datepicker range?

example:

ex: If i select Month January and year 2021 the filter datepicker range its 1/1/2021 to 31/01/2021

it's possible to force ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@a10703ant

Yes, you just need to have the DefaultDate property of the date picker be the value you want.

Ex. DatePicker1 DefaultDate property formula:

Date(yourYearDropDown.Selected.Value, yourMonthDropDown.Selected.Value, 1)

Your DatePicker2 DefaultDate property formula:

DateAdd(DateAdd(Date(yourYearDropDown.Selected.Value, yourMonthDropDown.Selected.Value, 1), 1, Months), -1, Days)

I hope this is helpful for you.

Was this reply helpful? Yes No
a10703ant 75 on at

Like (0)

Report
Copy link

Link copied!

What means the function for i understand the syntax?

yourMonthDropDown.Selected.Value, 1) why 1?

yourMonthDropDown.Selected.Value, 1), 1, Months), -1, Days) and why 1 Months and -1 days?

thanks

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@a10703ant

The Date function expects three parameters, the year, the month and the day. So, the formula:

Date(yourYearDropDown.Selected.Value, yourMonthDropDown.Selected.Value, 1)

will produce a date that is the first day of the selected year and month.

For the second datepicker, you wanted the last day of the month. So, the trick is to add 1 month to the first day of the month and then subtract 1 day. That will be the last day of that month.

DateAdd(DateAdd(Date(yourYearDropDown.Selected.Value, yourMonthDropDown.Selected.Value, 1), 1, Months), -1, Days)

So in the above formula, we again get the Year, Month and Day 1 date, and then add 1 month to it and subtract 1 day from it. That's the last day.

Was this reply helpful? Yes No