Finding available dates (equipment rental program)
I'm working on a rental type program and have run into a problem. I am trying to find a way for people to search when certain equipment will be available. Here's a bit more information.
People can reserve items in the future (ie. item A on reserve from Feb 1, 2011 to Feb 4, 2011). Now if another person comes by and wants to reserve item A. They select their start date as Feb 3rd and end date of Feb 8th. How can I get it to return a message saying that item A is not available (due to overlap)? I'm not far into the project so field or table set up doesn't really matter, they can all be changed to fit any solution.
I've thought about this for awhile, but can't seem to come up with any solutions. Has anyone worked with something like this?