Hello,

I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.

I would like to query this table to provide a list of active members between a given range of dates.

For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.

Any help is greatly appreciated. Cheers.

SELECT * FROM Membership_Table
WHERE Membership_Table.StartDate <= START_DATE_YOU_INPUT AND
Membership_Table.EndDate >= STOP_DATE_YOU_INPUT
;

SELECT * FROM Membership_Table
WHERE Membership_Table.StartDate <= START_DATE_YOU_INPUT AND
Membership_Table.EndDate >= STOP_DATE_YOU_INPUT
;

I would just like to expand on this query as it makes the assumption that the End Date will always be there. I usually find that while some people have a known end date, others tend to be unknown. So, a provision for blank end dates also needs to be made:


SELECT * FROM Membership_Table
WHERE Membership_Table.StartDate <= START_DATE_YOU_INPUT AND
(Membership_Table.EndDate >= STOP_DATE_YOU_INPUT Or
IsNull(Membership_Table.EndDate))