I have the following fields date and start time & end time.
Given this information i need to go to the room reservation database and pick up all the documents that matches start time and end time. Is it possible using db.search
for ex: 03/02/2005 and start time = 9:00 am , end time = 11:00 pm
rooms booked between the times mentioned above shoudl be returned, so if a room is booked between 9:30 - 10 or time between 7:00- 9:30 should be returned...the times are separted for every half and hour
Can anybody state the logic for me please using formulas
Thanks in advance