I have a fundraising solution working with pledges and contributions in
filemaker 8 for windows. I want to create a field that holds a date that is
2 weeks from the date they pledged. So i can create a script that will
search for all dates in that before today and it will automatically send out
my reminders. For example: If Joe blow pledges to 25$ on 10/20/05 I want to
know in another field if 14 days have transpired since the date pledged. I
also want one for 30 days out to send a second reminder. Then I can use
this calculation to create a script to find all entries between 14 days
earlier and 30 days and then another for 30 days or more. my guess is this
equation could go about 2 ways I could find the date and then add 14 days to
creat the new field... or I could just create an equation that would
subtract 14 days and them 30 days from today. Which would be easier and
what would the easiest solution be.

Scot Dunnachie

In article <11k214ismd4r4a2 (AT) corp (DOT) supernews.com>, "scotlandak"
<scotland (AT) nospam (DOT) ak.net> wrote:

You really only need one calculation that tests to see whether or not
"today" is already more than 14 days from the initial pledge date - if
it isn't you add 14, otherwise you add 30.
ie.

ReminderDate {Calculation, Date result, unstored}
= If(PledgeDate + 14 > Get(CurrentDate),
PledgeDate + 14,
PledgeDate + 30)

It depends a little on what you want to happen on the 14th day itself.
On the 14th day the calculation above will change to +30, but if you
want it to still remain as +14 then the > needs to be a >= (or „ if
that shows up on your screen).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)