Hello,
I am trying to create a vehicle reservation form and I want to pulldata or really search for dates from the previous / future reservations that have been entered for this vehicle to ensure that the current person requesting the vehicle’s checkout dates do not overlap. For example, if someone previously reserved the vehicle for 11/5/2023 to 11/8/2023 then when someone goes to try and reserve the same vehicle for any dates that overlap those dates it gives the requestor a message. If 11/2/2023 to 11/4/23 was requested no issues but 11/2/2023 to 11/6/2023 the system would post a message.
Is there anyway to do this?
