Creating a list of Donors who need to be thanked after 45 days of receiving their gift
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.