Brilliant! Thanks.

The hard-coded dates are there just for testing. I am hoping to use the dates and start terms as parameters in SSRS reports.

However, I am intrigued by your suggestion. Are you suggesting that in my date dimension that I apply a start term to a date as well? If so, I can't really do that only because applicants can defer their application to the following year which would then leave me with the possibility of having 2 start terms associated to a date. If not, I am open to any enhances that will make my data more dynamic and easier to manage.

Thanks.