2.0

Functions
9-32 Using Calculations
Upper
The Upper function returns a given string as uppercase.
Usage Example
Upper([str1])
If the field [str1] = Samantha Morrison
Then the calculation Upper([str1]) returns SAMANTHA MORRISON
In the example below, the
Salesperson
field is converted to all upper case
and put in the
Salesperson Last Name
field.
Year
The Year function returns the numeric year for a date. The year is
returned as CCYY.
Usage Example
Year([date1])
If the field [date1] = March 17, 1996
Then the calculation Year([Date]) returns 1996
In the example below, the century and year is extracted from the
Date
Entered
field and put in the
Century and Year
field.