I need users not to enter a date that is within the range of these fields, as they are used to mark the date of the meeting in a meeting room
Start Date and End Date
The format of these dates is as follows
Example 1 EntryStart dateJanuary 6, 2020 10:10
Final dateJanuary 6, 2020 10:40
as you can see they have a range of 10:10 to 10:40
I want to validate that they do not save a new date following the previous example
Example 2 EntryStart dateJanuary 6, 2020 10:25
Final dateJanuary 6, 2020 10:35
as you can see here they would conflict because I have 2 meetings at the same time
These 2 fields are of the selected string type with a date and time selector
for the hour and minutes a combo box is used
Go to Solution.
It worked correctly, I just had to adapt it to my needs as you explained it to me with DateTimeValue
DateTimeValue (DateStart.SelectedDate & "" & TimeStart.Selected.Value & ":" & MinStart.Selected.Value)
DateTimeValue(EndDate.SelectedDate & "" & FinalTime.Selected.Value & ":" & MinEnd.Selected.Value)
For all (
DateI> = DateTimeValue (Start Date) && DateI <= DateTimeValue (End Date) || DateF> = DateTimeValue (Start Date) && DateF <= DateTimeValue (EndDate) || DateI <= DateTimeValue (Start Date) && DateF> = DateTimeValue (End Date),
First (MeetingTaken) .Value = true,
Notify ("Time of meeting taken"),
Thank you very much for your help I understood it well
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!