|
You can do a simple find on a range of renewal
dates. Assuming you're set up to give a 3-month grace period, you won't
have any lapsed members with renewal dates later than 11/20/01. So enter
6/1/01...11/20/01 in the renewal date on the find screen and you should get the
right list.
Barb Welch
----- Original Message -----
Sent: Wednesday, February 20, 2002 12:45
PM
Subject: [support] find problem
HI,
I am trying to find the set of lapsed members
that had a renewal date after 6/1/01. I have tried several ways of
getting there, after making sure I had updated all find fields. in the
Names screen I did a Find All the Find with lapsed in the Mbr Status and
>=6/1/01 in the Renewal Date. This find gave me the same names as if
I had just done a find for all lapsed members with renewal dates well before
June 2001.
I tried the same criteria from the view payments
screen with Status: lapsed and Last Exp >=6/1/01. this also gave me
lapsed members with very old expiration dates out of my criteria.
I then tried doing the find from the query screen
which was also wrong.
What am I missing?
------------------ 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
---------------------------------------------------------------------
|