>we have a last contribution field that does not include last dollar given to >our organization (such as a gift for membership renewal). i have tried to >pull the start date of one's membership (since we can usually assume this >was the last dollar given), but this gives me all the person's entire start >date history... basically what i need is a way to export the last giving >date of an individual...any suggestions? >
From what you have said, I'm not entirely sure what you're looking for, so here's all the options I can think of. In the names file are fields FIND LAST DON. DATE which contains the date of the most recent payment marked as Contribution, and FIND LAST MBR DATE which contains the date of the most recent dues payment. In the summary file, MEM: LAST PAYMENT DATE contains the date of the last payment coded EITHER as Dues or Contribution. None of those fields appear on layouts, so you will need FileMaker to get access to them - go to layout mode, place them somewhere convenient, then you can use them in a search. -- -- Dave Shaw H4 Consulting tel: 206-954-7526 fax: 206-625-1338 ------------------ 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 ---------------------------------------------------------------------
