Answered

If function for date hour minute value

(2) Share

Report

Posted on by silviavg

Hi!

I need to condition a date&hour field in my canvas app according to another date of the form. I have two date & hour field, one called "Recolección cliente origen" and the other one called "Entrega cliente destino", what I need is to build a formula that does not allow the user to enter a date & hour in "Entrega cliente destino" less that "recolección cliente origen" date & hour. The formula I have right now is validating only the date but I need it to validate hour and minutes. how should I do it?

Thanks in advance for helping!

Categories:

Building Power Apps

All responses (12)

Answers (2)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Try this:

If( Or( (DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 )) < Today(), (DateValue2.SelectedDate + Time( Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0 )) < (DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 )) ), Notify(""), Error )
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Don't forget to change the if true and else notify bit at the end to what you want it to be:

, Notify(""), Error )
silviavg 86 on at

Like
a
(1)

Report
Copy link

Link copied!

It worked! thanks @AJ_Z
silviavg 86 on at

Like
a
(1)

Report
Copy link

Link copied!

@AJ_Z do you know how can I do to don't allow the user to send the form? actually we are only notifying him but I want to don't allow him to send the request if the date is wrong.
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Glad I could help 🙂
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Ofcourse how are you submitting the form? is it with a button if so we can change the displaymode?
silviavg 86 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, I already have this formula in the button. How can I add the new one?
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Would you be able to Paste both of your formulas in so I can copy it easily 🙂 and give you the combined formula
silviavg 86 on at

Like
a
(1)

Report
Copy link

Link copied!

Set(DateVar,DateValue2.SelectedDate + 30); If(DataCardValue10_1>DateVar,Notify("El tiempo de duración de jornada no puede ser mayor a 30 días",NotificationType.Error),SubmitForm(EditForm1_1))
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Here is the formula below added to the one you already did 🙂

Set( DateVar, DateValue2.SelectedDate + 30 ); If( DataCardValue10_1 > DateVar, Notify( "El tiempo de duración de jornada no puede ser mayor a 30 días", NotificationType.Error ), Or( (DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 )) < Today(), (DateValue2.SelectedDate + Time( Value(HourValue2.Selected.Value), Value(MinuteValue2.Selected.Value), 0 )) < (DateValue1.SelectedDate + Time( Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0 )) ), Notify( "No Puedo...", NotificationType.Error ), SubmitForm(EditForm1_1) )

change "No Puedo" to the full error message you wanted.

also just looking at your first condition:

DataCardValue10_1 > DateVar

I am not sure what DataCardValue10_1 is but if it is working and correct no worries I am leaving that part the same then 🙂