Hi everybody
I'm going crazy with the filter. part of code:
Set(DataFrom; DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value);Value(MinuteValue1.Selected.Value);0));;
Set(DataTo; DateValue2.SelectedDate + Time(Value(HourValue2.Selected.Value);Value(MinuteValue2.Selected.Value);0));;
ClearCollect(collBook; (Filter(BookingCar; DataStart >= DataFrom && DataEnd<= DataTo && DataStart <= DataTo )));;
.............
The user insert days and hour.
Example: book from 10/01/2022 08:00 to 10/01/2022: 15:00
If I book for example from 10/01/2022 08:00 to 10/01/2022: 10:00 it's work; but
If I book from 10/01/2022 09:00 to 10/01/2022: 10:00 it doesn't work.
Help me ☹️
Many thanks