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 Entry
Start date
January 6, 2020 10:10
Final date
January 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 Entry
Start date
January 6, 2020 10:25
Final date
January 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
Solved! Go to Solution.
Hi @Anonymous
It worked correctly, I just had to adapt it to my needs as you explained it to me with DateTimeValue
Look:
Set(
DateI,
DateTimeValue (DateStart.SelectedDate & "" & TimeStart.Selected.Value & ":" & MinStart.Selected.Value)
);
Set(
DateF,
DateTimeValue(EndDate.SelectedDate & "" & FinalTime.Selected.Value & ":" & MinEnd.Selected.Value)
);
Clear (MeetingTaken);
For all (
Training,
Yes (
DateI> = DateTimeValue (Start Date) && DateI <= DateTimeValue (End Date) || DateF> = DateTimeValue (Start Date) && DateF <= DateTimeValue (EndDate) || DateI <= DateTimeValue (Start Date) && DateF> = DateTimeValue (End Date),
Collect (
MeetingTaken,
true
)
)
);
If (
First (MeetingTaken) .Value = true,
Notify ("Time of meeting taken"),
Set(
Confirm,
true
)
)
Thank you very much for your help I understood it well
User | Count |
---|---|
246 | |
105 | |
82 | |
50 | |
43 |