ldStartDate = ... ldEndDate = ... * A treatment starts or ends between specified dates SELECT * FROM mytable ; WHERE StartDate BETWEEN ldStartDate AND ldEndDate ; OR EndDate BETWEEN ldStartDate AND ldEndDate * A treatment starts and ends between specified dates SELECT * FROM mytable ; WHERE StartDate BETWEEN ldStartDate AND ldEndDate ; AND EndDate BETWEEN ldStartDate AND ldEndDate>Hi! I have a form that allows the user to enter a date range. The program then scans through a table looking for treatments that are done at any time during the entered period ie between two dates.