Checking dates

[Guest]

I have a table with fields: number, start and end. Number field contains
random number (1-100). Start and end fields contains dates. In additional I
have form from where user can check those days from the table. Let me but an
example "picture"

This is the table
NUMBER | START | END |
3 | 17.6.2005 | 18.6.2005 |
67 | 11.6.2005 | 12.6.2005 |
15 | 12.6.2005 | 13.6.2005 |

For example user enters in form dates: start-> 13.6.2005 and end
->14.6.2005. Now fuction should check all records from table(start and end
fields) and return number field's value if start and end dates doesn't match.
This means that entered dates are smaller than table's start date or bigger
than end date. So from picture first record(3) is good because entered dates
are smaller. Second one (67) is good because entered dates are bigger. Third
case(15) end date is reserved so it is not good. So 3, 67 will be returned to
form's list. Probably this is very easy to do, but I don't know how to do it.
Help would be appreciated. Thanks.

 

[Allen Browne]

I think you are asking how to check and see if the dates in any records
overlap with dates in other records?

If so, see:
Clashing Events/Appointments
at:
http://allenbrowne.com/appevent.html