|
<< Click to Display Table of Contents >> Navigation: Available Functions > NthSolDLFollowUp |
Nth Solicitation, Date Of Last Follow-Up
Syntax
NTHSOLDLFOLLOWUP( <SolicitationNumber> )
Purpose
To retrieve the last follow-up date for the nth solicitation.
Parameters
<SolicitationNumber> is the unique number for the desired solicitation. Solicitation numbers are generated in ascending order by DonorQuest, starting from 1 and going up to 999.
Returns
The date of the last follow-up for the specified solicitation.
Usage
On reports the NTHSOLDLFOLLOWUP() function can be used to retrieve the date of the last follow-up phone call or mailing for the nth solicitation in each donor's history.
Example
The following examples illustrate NTHSOLDLFOLLOWUP():
MEMO CODE |
MEMO TEXT |
|---|---|
S000001 |
02/01/2011; GOLF ; Last Follow-Up: 05/15/2011; Number Of Follow-Ups: 4 |
S000002 |
02/01/2012; CAPTL; Last Follow-Up: 04/20/2012; Number Of Follow-Ups: 2 |
CALL |
RESULT |
|---|---|
NTHSOLDLFOLLOWUP( 1 ) |
05/15/2011 |
NTHSOLDLFOLLOWUP( 2 ) |
04/20/2012 |