AnsweredAssumed Answered

Creating a list of Donors who need to be thanked after 45 days of receiving their gift

Question asked by MartinLange on Feb 19, 2013
Latest reply on Feb 19, 2013 by MartinLange

Title

Creating a list of Donors who need to be thanked after 45 days of receiving their gift

Post

      

I’m running a Donor Management database on FMP 11, and I am trying to create a notification when it has become critical to thank a donor for a donation. I have two date fields that I want to compare - DonorManagement::LastThanked and DonationEntry::LastGiven. I want to generate a script that creates a list of all donors who have not been thanked within the last 45 days or more.

      

I have tried writing a script, but it does not generate the result I want. I am performing a find, but when I try to find if the LastThanked field is more than 45 days old I get the following message: 

      

The value of this field must be a valid date in the range of years 1 to 4000 and should look like “12/25/2003”.

      

I am really baffled how to create a Find function that compares the “Last Given” date field with the “LastThanked” date field to determine what needs to be thanked right away and generate a PDF report that I can print.

      

I am not a total newcomer to FMP, but I don’t have the depth of knowledge needed to tackle this problem. Any nudges in the right direction would be appreciated.

Outcomes