Help with Date

[RubesandBoogs]

Hi Powerapp Gurus

Need some assistance with date....

I have 2 fields from a sharepoint list;

When did this accident occur?

When was this accident discovered?

I am wanting to put a formula where the accident discovered cannot be before the date entered in accident occur.

Thanks in advance

Rae

[WarrenBelz · Accepted solution]

Hi @RubesandBoogs ,

Put on the OnChange of Accident Discovered date picker (change to your control names) - this also allows for a blank occur date.

If(
  AccidentDiscoveredControl.SelectedDate < AccidentOccurredControl.SelectedDate ||
  Value(AccidentOccurredControl.SelectedDate)=0,
  Notify(Cannot be before occurrence date, Error);
  Reset(YourAccidentDiscoveredControl)
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[eka24]

Assuming you are using AfterDatePicker and BeforeDatePicker, on your submit or Patch button put:

If(BeforeDatePicker.SelectedDate>AfterDatePicker.SelectedDate, Notify ("Check the date entered, Before Date, cannot be greater than After Date"), SubmitForm (YourFormName))

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[RubesandBoogs]

Awesome, thanks @WarrenBelz 

[WarrenBelz]

No problem @RubesandBoogs ,

Was my post the solution?

[RubesandBoogs]

Yes, thank you

[WarrenBelz]

@RubesandBoogs ,

That was not the one you accepted - please consider correcting this for the benefit of others viewing in the future.

[RubesandBoogs]

Sorry @WarrenBelz , first time user of the support function, now corrected