AnsweredAssumed Answered

determining next issue

Question asked by jayGamel on Jul 22, 2011
Latest reply on Jul 22, 2011 by philmodjunk


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?