I went with a simple table route rather than trying to identify values on the fly. There were some strange errors around December and January months who was throwing the...

Working on it!

That is correct. And going forward too of course. I am imagining when we hot 8/1/2010, my academic year would now be 1011 instead of 0910. So on and so...

I don't want this to be a table driven query for teh same reason you describe - I need to remember every year to go and update the values in...