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
---------------------------------------------------------------------
