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

Reply via email to