Thank you for the suggestion. Unless I am missing something, I think that our two solutions are the same...I check for the same 3 conditions that you are...the only...

Great idea...And if this becomes more than a one time ad-hoc request...that is surely going to happen.

Thanks.

Well,

sometimes you just need to write down what you're trying to do..to gain a little perspective.

I added another WHEN statement for each war...and if the war start date was within...