((A.BookSDate>=B.BookSDate)and(A.BookSDate<=B.BookEDate))or((B.BookSDate>=A.BookSDate)and(B.BookSDate<=A.BookEDate))
