...
Table 2: Data for Aggregate Functions Examples
In TouchPoint, the available aggregate functions are:
Occurrences
Counts the number of records for the customer. For customer 123, Count Occurrences is EQUAL to 4.
...
DATE FUNCTIONS
In addition to aggregate functions, TouchPoint offers built-in date functions for calculating intervals between the current system date (i.e. time and date according to the host) and a date field in your database. For example, you run a daily campaign to select all customers who have magazine subscriptions expiring in ninety days. You can use the DaysUntil date function to set up the following statement:
DaysUntil of Expiration_Dt is Equal to 90
During selection, the DaysUntil function looks at the Expiration_Dt and compares it to the current system date on your computer to see if the number of days between the expiration dates equals 90. You can run this same campaign each day without changing the criteria because the DaysUntil function always uses the current system date as the basis for comparison, saving you campaign creation time.
In TouchPoint, the list of available date functions are:
DaysUntil
Calculates the number of days until the designated date field based on the system date on your computer.
...