1 of 1 people found this helpful
You need to add a date field where you can enter today's date each time a renewal notice is sent for a given member record. You might have one data field, for date of last renewal notice or you might set up a related table where you add a new record each time you send out a renewal notice to a member.
Get ( CurrentDate ) is the expression that you can use to add this date to a field in your solution. If you have a found set of records to update, Replace Field Contents can do this with the calculation option or you can use a looping script with set field to do the same.
You then need a field in the same record to record the date of any member response.
To find member records where the member records did not respond, you find all records where the date in the first date field (date notice was sent) is 14 days or older than today where the response date field is still empty.
Enter find mode [ ]
Set field [Members::DateRenewalNotice ; "<= " & Get ( CurrentDate ) - 14 ]
Set Field [Members::RenewalResponse ; "=" ]
Set Error Capture [on]
Perform Find [ ]
Thank you for this - it's very helpful & gives me lots to think about (unfortunately I only have limited time to spend on this project, so it will be Friday before I can look at it again... very frustrating as I want to get cracking straight away!).