The report below identifies an employee's earliest appointment to the campus by using the prefix operator MIN to identify the minimum effective date. The data is held to a temporary hold file and then evaluated to determine if the minimum effective date is greater than or equal to a specific date. In the example below, the screening date is January 1, 2001.
TABLE FILE TR
on table hold
table file hold
if tr:effdate ge 01012001
For an additional example of using prefix operators, see the sample program: Minimum, Maximum and Average Salary By Class.
Related Topic: Identifying An Employee's Most Recent Appointment
Last Updated: April 2, 2001