It sounds like you are looking to quantify the "closeness" of the start and end dates of a given record in one set to all the records in the other, correct? If so, you could create a score using the DATDIF function to get the difference, and use the absolute value to determine how close they are. The sum of the absolute value of the differences could be the overall score for closeness.
... View more