Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Expression Builder Functions

The following table lists the functions that you can use in Expression Builder. Click the name of a function to see more information about the function.

Boolean Functions

Date and Time Functions

String Functions

User Functions

Data Functions

Math Functions

IfNull

JulianDay

FieldValue

Alias

ExcludeChannel

LN

IIf

JulianMonth

FindNoneOf

Currency

GetGroupId

 

 

JulianQtr

FindOneOf

DivisionName

GetParentId

 

 

JulianWeek

InStr

FirstName

LookupName

 

 

JulianYear

Left

JobTitle

LookupValue

 

 

Timestamp

Len

Language

PRE

 

 

Today

Mid

LanguageName

RowIdToRowNum

 

 

UtcConvert

Right

LastName

RowNum

 

 

 

ToChar

LocalCurrency

 

 

 

 

 

Locale

 

 

 

 

 

LocaleListSeparator

 

 

 

 

 

LocaleName

 

 

 

 

 

LoginId

 

 

 

 

 

LoginName

 

 

 

 

 

OrganizationName

 

 

 

 

 

UserValue

 

 

Some of the functions listed in the drop-down list on the Functions field in Expression Builder are for internal use only. Do not use the following functions in your expressions:

  • IsManagerPosition
  • Lookup
  • LookupMessage
  • LOVLanguage
  • PositionId
  • PositionName

It is recommended that you use the UserValue function instead of the following functions:

  • Alias
  • Currency
  • DivisionName
  • FirstName
  • JobTitle
  • Language
  • LanguageName
  • LastName
  • LocalCurrency
  • LocaleName
  • LoginId
  • LoginName

Related Information

See the following topics for related Expression Builder information:


Published May 2008