Using TSQL I am looking for a way to pull a list of committee members based on the timeframe they were actively on the committee to be isolated by year. Unfortunately I have a start and end date that in most cases represents a three year assignment, so the standard BETWEEN clause doesn’t appear to answer the question.
Member StartDate EndDate
John 7-1-2013 8-15-2016
Mary 5-1-2012 2-15-2014
Jane 4-1-2011 8-15-2014
I need to determine if the start and end date range is active during a date range say 7-1-2013 thru 6-30-2014 then the fiscal year shown would be 2014.