morinia
asked on
Checking to see if a member enrolled in a certain time period
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
01-01-2009 06-30-1009
07-01-2009 12-31-2009
01-01-2010 06-30-2010
Is there a way to check to see if a member was enrolled at any time between two dates.
Example:
I would like to check to see if a member was enrolled between 03-01-2009 and 07-31-2009?
Example: Enroll Exit
01-01-2009 06-30-1009
07-01-2009 12-31-2009
01-01-2010 06-30-2010
Is there a way to check to see if a member was enrolled at any time between two dates.
Example:
I would like to check to see if a member was enrolled between 03-01-2009 and 07-31-2009?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.