Functions and Available Formats

The following is an overview of the functions and their available formats:

String

Function

Tooltip

(indexOf(String, int))

Starting point of a string within another string starting at a defined point in the string.

(indexOf(String))

Starting point of a string within another string starting at the beginning of the string.

(length())

Length of a string.

Formatting a numeric field to a string, for example: numeric value of 9 with a format of "00000.00" would result in a string of "00009.00".

(startsWith(String, int))

Checking to ensure if a string starts within a defined string starting from a defined index. Needs to support indexOf.

(startsWith(String))

Checking to ensure if a string starts within a defined string.

(endsWith(String))

Checking to ensure if a string ends with a defined string.

(substring(int))

Pulling a substring from another string starting at a defined point till the end. This needs to support indexOf.

(substring(int, int))

Pulling a substring from another string starting at a defined point till a defined point in the string. This needs to support indexOf.

(concat(String))

Concatenating stings including being able to define numeric fields as strings.

(contains(String))

Checking to ensure if a string contains another string.

Comparing strings

Not available.

Numeric

Function

Tooltip

(toString(format))

Converting a number or currency to a string with a defined format.

(abs())

Absolute value of a number

(sqrt())

Square root of a number.

(power(int))

Raised to the power.

(log())

Logarithm Base 10.

(ln())

Natural Logarithm.

(min(number, ….))

Minimum of a set of numbers.

(max(number, ….))

Maximum of a set of numbers.

(ceil())

Round up to the smallest integer that is greater than or equal to the value of the field.

(floor())

Round down to the largest integer that is less than or equal to the value of the field.

(round(int))

Round to the number of decimal places.

Comparingnumbers =, !=, >, >=, <, <=

Not available.

Date

Function

Tooltip

(toString(format))

Converting a date to a string based on a defined format.

Converting a datetime to a date only

Not available.

Add or subtract number of days from a date

Not available.

Add or subtract number of months from a date

Not available.

Add or subtract number of years from a date

Not available.

Extracting day, month, or year from a date.

Not available.

Comparing Dates =, !=, >, <

Not available.

The following provides the list of functions:

Note: Use the tooltip to learn more about each function.

String Functions

Numeric Functions

Date Functions

  • compare(str1,str2)
  • compareIgnoreCase(str1,str2)
  • concat(str1,str2)
  • contains(str,search)
  • containsAny(str,search1,search2,...)
  • containsIgnoreCase(str,search)
  • endsWith(str,suffix)
  • endsWithIgnoreCase(str,suffix)
  • indexOf(str,search)
  • indexOfAny(str,search1,search2,...)
  • indexOfIgnoreCase(str,search)
  • isAlpha(str)
  • isBlank(str)
  • isEmpty(str)
  • isNumeric(str)
  • isNumericSpace(str)
  • lowerCase(str)
  • upperCase(str)
  • matches(str,regex)
  • left(str,len)
  • leftPad(str,size)
  • leftPad(str,size,padStr)
  • mid(str,pos,len)
  • right(str,len)
  • rightPad(str,size)
  • rightPad(str,size,padStr)
  • replace(str,search,replacement)
  • replaceAll(str,regex,replacement)
  • replaceFirst(str,regex,replacement)
  • startsWith(str,prefix)
  • startsWithIgnoreCase(str,prefix)
  • size(str)
  • strip(str)
  • substring(str,start)
  • substring(str,start,end)
  • truncate(str,maxlen)
  • abs(num)
  • max(num1,num2)
  • min(num1,num2)
  • ceil(num)
  • floor(num)
  • log(num)
  • log10(num)
  • pow(base,exponent)
  • round(num,places)
  • sqrt(num)
  • isNumber(num)
  • numberFormat(num,pattern)
  • toDouble(num)
  • toInt(num)
  • toLong(num)
  • cos(num)
  • sin(num)
  • tan(num)
  • acos(num)
  • asin(num)
  • atan(num)
  • cosh(num)
  • sinh(num)
  • tanh(num)
  • date(year,month,day)
  • day(date)
  • edate(date,months)
  • eomonth(date,months)
  • month(date)
  • now()
  • today()
  • weekday(date)
  • weeknum(date)
  • year(date)
  • addDays(date,amount)
  • addHours(date,amount)
  • addMonths(date,amount)
  • addWeeks(date,amount)
  • addYears(date,amount)
  • dateDiff(start,end)
  • dateFormat(date,pattern)
  • isSameDay(date1,date2)
  • toLong(date)
  • toDate(long)


Last Published Monday, June 3, 2024