Your definition looks modified from the original (mine is too so I can't be sure). But if you change it to be post date then expire date is certainly a misleading name. Post date is intended to reflect the date on the check which may not correspond to the Start date if for instance someone pays for a year membership a month or two ahead of actual due date. Or as frequently happens pays within the grace period where we set the start date to be when the old one expired so they don't get a month or two free just by paying late.
Our change has to do with life members where we expire them all at the same date 2250 which is far enough in the future that none of us will be around for the event or have to fix the code. We originally just used a duration of 100 years but then we had a member who gave life memberships to each grandchild and they had the possibility of outliving the expire date. > -----Original Message----- > From: Christopher Donnelly [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 04, 2002 3:34 PM > To: TechRocks Support > Subject: [support] EXPIRE DATE > > > We have located a problem in eBase with our expiration date. > > We would like our expire date to coincide with the "post date" of the > latest payment recieved from our members. > > Can we redefine the expire date field to do this with out losing other > calculations and scripts? > > Currently the calculation for expire date is the following: > > Case( > Payment For <> "Dues", TextToDate(""), > IsEmpty(Start Date),TextToDate(""), > Duration = "Indefinite", Names::gToday+730, > Min( > Date( > Month(Start Date) + > If(PatternCount(Duration,"M"),TextToNum(LeftWords(Duration,1)),0), > Day(Start Date), > Year(Start Date) + > If(PatternCount(Duration,"Y"),TextToNum(LeftWords(Duration,1)),0)), > Date( > Month(Start Date) + 1 + > If(PatternCount(Duration,"M"),TextToNum(LeftWords(Duration,1)),0), > 1, > Year(Start Date) + > If(PatternCount(Duration,"Y"),TextToNum(LeftWords(Duration,1)),0)) - > 1)) > > > HELP! > > ------------------ > Reminder to each recipient: To change your list account preferences, go to > http://email.sparklist.com/scripts/lyris.pl?enter=support and > enter the email address you used to subscribe to the ebase > support list:: [EMAIL PROTECTED] > > To unsubscribe send a blank email to [EMAIL PROTECTED] > --------------------------------------------------------------------- > ebase - Relationship Management for Nonprofits, http://www.ebase.org > --------------------------------------------------------------------- > > ------------------ Reminder to each recipient: To change your list account preferences, go to http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------
