Ensure one datepicker is before the other

(1) Share

Report

Posted on by RJM07

801

Hi all,

Quick question,

I have 2 datepickers on my screen and I need to ensure that the Start date is before than the expiry date, I can't seem to figure it out.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (2)

Report
Hi @RJM07

Please enter the following formula on the "OnChange" property of Start Date datepicker control:

If(Self.SelectedDate >= enddate.SelectedDate,Notify("Start date should be less than end date"));Reset(Self);
If start date is more than or equal to end date then it will notify the user and reset to default value. If you want to make start date as blank then set "DefaultDate" property to no value.

Please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (2)

Report

I can think of 2 solution.
The new date picker (actually there are 2 new date pickers, one in canvas apps, and one in Teams app and components. The Teams/Component has this feature, the other has not. You have to go to setting in your app to turn them on. Search modern controller. To add it to a Canvas app, start a new component, add it to the "app" and copy it and paste it into you canvas app.

The new date picker is way better than the old, but keep in mind its not datePicer.SelectedDate, but DatePicker.Value and some other minor changes.

In advanced you can set minimum date or something like that, locking the ability to select date before that time. This could be from input from another date picker as you need.

Old fashion solution
The other solution is to change color to date text to red if it is < StartDate.SelectedDate, add a warning text (if you want) and disable the "save button" if endDate.SelectedDate < StartDate.SelectedDate

Was this reply helpful? Yes No