|
<< Click to Display Table of Contents >> Navigation: Available Functions > NthSolDate() |
Syntax
NthSolDate( <SolicitationNumber> )
Purpose
To retrieve the 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 entered for the specified solicitation.
Usage
On reports the NthSolDate() function can be used to retrieve the date for the nth solicitation in each donor's history.
Example
The following examples illustrate NthSolDate():
MEMO CODE |
MEMO TEXT |
|---|---|
S000001 |
02/01/2015; GOLF ; Last Follow-Up: 05/15/2015; Number Of Follow-Ups: 4 |
S000002 |
02/01/2016; CAPTL; Last Follow-Up: 04/20/2016; Number Of Follow-Ups: 2 |
CALL |
RESULT |
|---|---|
NthSolDate( 1 ) |
02/01/2015 |
NthSolDate( 2 ) |
02/01/2016 |