[thelist] Help with app. logic

Karen J. Bowen lists at miinx.com.au
Fri Sep 27 21:36:01 CDT 2002


Susan Wallace wrote:
 > So if I evaluate the current date and quarter, how do I go about
 > determining the back issues?
 >

Hi Susan, don't think I saw any replies to this, did you get it sorted?

My thoughts from what you've said:

You've got:
- current date
	- therefore also current quarter
- original joining date
	- therefore also original joining quarter
	- therefore also original last publication received

So:
Back_issues_to_get = (current_quarter) minus
(last_publication_received_quarter + 1)

* plus one as they do get that last publication

To illustrate...
We have:

quarters:		Q1	Q2	Q3	Q4
journals:		B	C	D	A

and so for Person X:

joins Q2:			here
last pub rcvd:		this
rejoins Q4:					here

so needs

Q4 - (Q1+1) = 2

and you can calculate 2 back from Q4.

Actually, you could probably just make that:

Back_issues_to_get = (current_quarter) minus (first_quarter)

HTH
Karen
-------
Miinx Design & Development
e :: karen at miinx.com.au
p :: 0413.880.302
w :: www.miinx.com.au





More information about the thelist mailing list