Functions in Formula Expressions

Functions in Formula Expressions

From LongJump Support Wiki

Functions in Formula Expressions (Redirected from Formula Functions)
Jump to: navigation, search

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

The reference information for each Formula Function includes:

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

Contents

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

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
intAn integer,for example, a number representing the number of days (or months or years)
valueAn 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]
Personal tools