I have a table that has two fields enroll_date and exit_date. A member may have multiple records for different enrollments.
Example: Enroll Exit
Is there a way to check to see if a member was enrolled at any time between two dates.
I would like to check to see if a member was enrolled between 03-01-2009 and 07-31-2009?