Hi! I'm looking for some help with querying date ranges.
I have a list of operators approved to do contract work. As they are booked to do work, the start & end dates are recorded in a table along with the WO number. As operators are needed for new work, a user will use a form to enter txt_StartDate & txt_EndDate. How can I use this date input, along with the data below (example of table) to select who should be contacted for the new work? Must be lowest rate operator available.
Examples: txt_StartDate=12/2/11 8am; txt_EndDate=12/2/11 3pm. Next available operator should be #2. txt_StartDate=12/4/11 12pm; txt_EndDate=12/4/11 5pm. Next available operator should be #1.