Functions

A2J Author® has a number of built in functions which can be used in evaluations under the advanced tab. Some can also be used to return a value in the text of a question.

Name

Parameter

Purpose

Sample

Result

AGE

any date

Converts date to age in year

AGE([User Birthday])

20 if User Birthday is 1/1/1980 and the current date is 1/1/2000

DATE

date or days

Converts days into a mm/dd/yyyy date

DATE(TODAY+90)

the date 90 days from today

DOLLAR

number

Formats a number with commas and period

DOLLAR(38581.3)

38,581.30

HASANSWERED

a variable

Returns true if the variable has a value

HASANSWERED([middle name])

true if client typed in a middle name, false otherwise.

HISHER

gender

Returns his or her depending on gender

HISHER(User Gender)

“her” if User Gender is Female

HESHE

gender

Returns he or she depending on gender

HESHE(User Gender)

“he” if User Gender is Male

HIMHER gender Returns him or her depening on gender HIMHER(User Gender) "her" if User Gender is Female

ORDINAL

number

Returns ordinal form of number

ORDINAL(5)

5th

ROUND

number

Round a number to an integer

ROUND(5.21)

5

ROUND2

number

Rounds a number to 2 places after decimal.

ROUND2(5.215)

5.22

SUM

repeating variable

Returns total of all the repeating variables

SUM([Asset Value])

If you asked for 3 asset values which are stored in a repeating variable, this would return the sum of these 3 values

TODAY

None

Returns today’s date

TODAY

Today’s date as a Date variable

TRUNC

number

Truncates a number to an integer

TRUNC(7.98)

7

TRUNC2

Number

Truncates a number at hundredth place.

TRUNC(7.479)

7.47

CONTAINS

Any variable type

Evaluates if that variable contains a text string

CONTAINS([Variable name], "value")

True or False response