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

The reference information for each Formula Function includes:

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

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 IF ISCHANGED

ISNEW ISNULL

NOT OR

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

Uncategorized Functions

LOOKUP

PRIORVALUE