List Lookup based on entered start time & end time

it's not possible with lookup control nor with lookup function. they both support only simple single condition for equality.

I guess it might be possible with web request  control, if you are on enterprise license.

Hi Marian,

Thanks for your replied.

I wanted to use sharepoint calendar as our meeting room booking. but the current calendar allow overlapped booking (events).

do you have any suggestion on this ?

thanks

you could make the overlapping check with a workflow. there you'd have much more flexibility.

consider it just like user is requesting to book a room. but booking is performed by a workflow.

if there is no other overlapping event, workflow writes new event to the calendar and sends confirmation. if it overlaps with already booked event workflow would send a reject notification.

just like outlook does...