(Last updated May 2020)
A2J Author® has a number of built in functions which can be used to evaluate data in the logic section, question text, or Learn More sections.
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 the resolved string value of [Variable name] exists in "some other string" |
CONTAINS([Variable name], "value") |
True or False response |