• If you are looking for closest to the start date or end date, you could just use a query to identify all the records that are between them, and then use either MIN(), or MAX() For the date closest to the start date or the end date respectively.