determining next issue
I need to pick out a number from a list that depends on the date. magazine publishes 22 issues a year. based on today, I want to pick the issue number of the next issue coming up and use if for several functions, finding advertisers to call, classifieds to call, billing dates, etc. It is driving me bats, but I know it should be simple.
I have a table of print dates and issue numbers. I can figure out subscription end dates with a self-join, but I need the current issue as a global number I can pick up for other tables. How can I set it up and keep it current?