Answered

Date Picker Restrictions

(0) Share

Report

Posted on by CJ-26061806-0

I am working in PowerApps on an app that requires users to enter a present or future date in one date picker, and an older date in another date picker. In my testing I have noticed that I started entering the older date in the wrong date picker ( the one that needs a present or future date)

I am thinking an 'If' statement for each datepicker would work, but I'm not sure what terminology to use to identify which dates are incorrect to use.

For the one requiring it could be If(dpAppointmentDate 'is not current or newer date'), Notify("Blocked: A 'Rehire' Scenario requies a Prior Separation Date.", NotificationType.Warning), (not sure what terminology to code regarding identifying the date restriction),

Any advice on how to do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @CJ-26061806-0,

You can compare the selected date with Today() in your If statement.

For the appointment date (must be today or a future date):

If(dpAppointmentDate.SelectedDate < Today(), Notify("Appointment Date must be today or a future date!", NotificationType.Warning,2000) )

For the prior separation date (must be in the past):

If(dpPriorSeparationDate.SelectedDate >= Today(), Notify("Prior Separation Date must be before today!", NotificationType.Warning,2000) )

or you can put above validation on Submit button first check both date is valid if valid then only execute the submit form code..

If( dpAppointmentDate.SelectedDate < Today(), Notify( "Appointment Date must be today or later!", NotificationType.Warning, 2000 ), dpPriorSeparationDate.SelectedDate >= Today(), Notify( "Prior Separation Date must be before today!", NotificationType.Warning, 2000 ), SubmitForm(YourFormName) )

Note:

dpAppointmentDate - Please replace with your control name

dpAppointmentDate - Please replace with your control name

YourFormName - Please replace with your control name

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
CJ-26061806-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I had it very close but had forgot to put '.SelectedDate' after dp_NewAppt I put this in my date picker in dp_NewAppt.OnChange.

Was this reply helpful? Yes No