Formula Functions

Formula functions are logical and programmatic functions, used with fields and operators to build Formula Expressions in any of the following platform elements:

• Formula Fields
• Validations
• Formulas in Computed Fields
• Policy triggering criteria in Action-Based Data Policies
• Update Record Action in Data Policies.

The reference information for each Formula Function includes:

• Format (syntax) of the Function
• Argument(s)
• Description(s)
• Return Value
• Examples

Date Category

See Date for details about these Day, Date and Time-related formula functions:

DATE DATEADD DATECOMP DATEPART DATESUB DATEVALUE DAY

HOUR MINUTE MONTH NOW NULLDATE NULLTIME SECOND

TIME TIMEPART TIMEVALUE TODAY WEEKDAY YEAR

Logical Category

See Logical for details about functions resulting in TRUE/FALSE (YES/NO, 1/0):

AND IF ISCHANGED

ISNEW ISNULL

NOT OR

Math Category

See Math for details about mathematical functions:

ABS CEIL EXP FLOOR

LN LOG MAX MIN

MOD POW ROUND SQRT

Text Category

See Text for details about text-related formula functions:

CONCAT CONTAINS ENDSWITH FIND LEN

LOWER REPLACE STARTSWITH SUBSTRING

TEXT TRIM UPPER VALUE

Uncategorized

LOOKUP

PRIORVALUE

Conventions

The following conventions are used in this document:

Element	Description
string	Strings must be enclosed with single quotes
dString	Date strings must be enclosed with single quotes
int	An integer,for example, a number representing the number of days (or months or years)
value	An argument in date- and date/time-related Formula Functions, which defines a unit of time
[ ,optional]	Optional values are shown in brackets, as [ ,option1, option2]