﻿ Index of Functions
 Index

Working with Formulas > Functions Used in Formulas > Index of Functions

Below is a list of all available functions; click on the function name for further information:

Function Name

Type

Description

Abs()

Numeric

Calculates the absolute value of a number

Acos()

Numeric

Calculates the arc cosine of a number

Asin()

Numeric

Calculates the arc sine of a number

Atan()

Numeric

Calculates the arc tangent of a number

Avg()

List

Calculates the average of a list

Ceiling()

Numeric

Calculates the smallest number greater than or equal to an input number

Chr()

Text

Converts numeric ASCII character codes to alphabetic and special characters

Contains()

Text

Determines if a search string is included in an input string

Cos()

Numeric

Calculates the cosine of a number

Curdate()

Date/Time

Returns the current system date

Date()

Conversion

Converts a character string to a date

Day()

Date/Time

Returns a day from an input date

Dayname()

Date/Time

Returns the name of the day of the week from an input date

Dayofweek()

Date/Time

Returns the number of the day of the week from an input date

Empty()

Other

Determines if a field has a null or empty value

Exp()

Numeric

Calculates the constant E raised to a power of a number

Floor()

Numeric

Calculates the largest number less than or equal to an input number

Hour()

Date/Time

Returns an hour from an input date

Iif()

Other

Returns one of two values based on a Boolean statement

Instr()

Text

Returns the position of a search string in an input string, starting from the left

Isnull()

Other

Determines if a field has a null value

Left()

Text

Returns the leftmost characters in a string

Length()

Text

Returns the number of characters in a string

Lfind()

Text

Returns the position of a search string in an input string, starting from the left

Ln()

Number

Calculates the natural log of a number

Log()

Numeric

Calculates the logarithm of a number in a specified base

Lower()

Text

Converts all characters in a string to lowercase

Text

Adds characters or spaces to the left side of a character string

Ltrim()

Text

Removes characters or spaces from the left side of a character string

Max()

List

Calculates the maximum value from a list

Min()

List

Calculates the minimum value from a list

Minute()

Date/Time

Returns a minute from an input date

Mod()

Numeric

Calculates the remainder of the numerator divided by the denominator

Month()

Date/Time

Returns a month from an input date

Monthname()

Date/Time

Returns the month name from an input date

Pi()

Numeric

Returns an approximation of the number Pi

Power()

Numeric

Calculates the base raised to a power of a number

Proper()

Text

Converts the first character each part of a string to uppercase and all other characters to lowercase

Rand()

Numeric

Calculates a random number between zero and one

Recid()

Other

Returns a string that uniquely identifies a record

Recno()

Other

Returns a number indicating the absolute position of a record in a data set

Regexp()

Text

Returns a portion of a string that matches the regular expression given by the match string

Repeat()

Text

Repeats the characters in a string for a specified length

Replace()

Text

Replaces each occurrence of a search string in an input string with another string

Reverse()

Text

Reverses the order of characters in a string

Rfind()

Text

Returns the position of a search string in an input string, starting from the right

Right()

Text

Returns the rightmost characters in a string

Round()

Numeric

Rounds a number to a specified precision

Text

Adds characters or spaces to the right side of a character string

Rtrim()

Text

Removes characters or spaces from the right side of a string

Second()

Date/Time

Returns a second from an input date

Sign()

Numeric

Returns the sign of a number

Sin()

Numeric

Returns the sine of a number

Soundex()

Text

Returns a phonetic representation of a string

Stddev()

List

Calculates the standard deviation of a list

Str()

Conversion

Converts a date or numeric value to a character string

Strpart()

Text

Returns the nth section of an input string

Substr()

Text

Returns a portion of an input string

Sum()

List

Calculates the sum of a list

Tan()

Numeric

Calculates the tangent of a number

Translate()

Text

Replaces each character in a string with a corresponding character in a search list with a character from a replace list

Trim()

Text

Removes characters from the left and right sides of an input string

Trunc()

Numeric

Truncates a number to a specified precision

Upper()

Text

Converts all characters in a string to uppercase

Val()

Conversion

Converts a character string to a numeric value

Variance()

List

Calculates the variance of a list

Week()

Date/Time

Returns a week from an input date

Year()

Date/Time

Returns a year from an input date