Formula Functions

From AgileApps Support Wiki
Revision as of 22:53, 25 March 2014 by imported>Aeric

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

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

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