Formula Functions

About the 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:

• Computed Fields in Reports
• Custom Access Criteria
• Default Field Values
• Formula Fields
• Layout Rules
• Macros#Visibility Criteria
• Rules#Execution Criteria
• Rule Actions to add or update a record
• Validation Criteria

Conventions

The following conventions are used in these functions:

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]

Date Functions

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 Functions

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

AND OR

IF NOT

ISCHANGED ISNEW ISNULL

Math Functions

See Math for details about mathematical functions:

ABS CEIL EXP FLOOR

LN LOG MAX MIN

MOD POW ROUND SQRT

Text Functions

See Text for details about text-related formula functions:

CONCAT CONTAINS ENDSWITH FIND LEN

LOWER REPLACE STARTSWITH SUBSTRING

TEXT TRIM UPPER VALUE

Aggregate Functions

The Aggregate Functions are not available in every context, because of their potential impact on performance. They let you select a collection of records in an arbitrary object and perform a summary calculation on those records.

(For most purposes, a Rollup Summary Field tends to be more useful, as it lets you define a summary calculation for a set of related records--for example, to sum the line items in an order.)

MAXIMUM MINIMUM

SUM AVG

COUNT

Miscellaneous Functions

LOOKUP

PRIORVALUE