Abs
|
Returns the absolute value of a numeric
value or expression.
|
Arithmetic
|
Apr
|
Returns the annual percentage rate for a
loan.
|
Financial
|
At
|
Locates the starting character position
of a string within another string.
|
String
|
Avg
|
Evaluates a set of number values and/or
expressions and returns the average of the non-null elements contained
within that set.
|
Arithmetic
|
Ceil
|
Returns the whole number greater than or
equal to a given number.
|
Arithmetic
|
Choose
|
Selects a value from a given set of parameters.
|
Logical
|
Concat
|
Returns the concatenation of two or more
strings.
|
String
|
Count
|
Evaluates a set of values and/or expressions
and returns the number of non-null elements contained within the
set.
|
Arithmetic
|
CTerm
|
Returns the number of periods needed for
an investment earning a fixed, but compounded, interest rate to
grow to a future value.
|
Financial
|
Date
|
Returns the current system date as the number
of days since the Epoch
|
Date and Time
|
Date2Num
|
Returns the number of days since the Epoch,
given a date string.
|
Date and Time
|
DateFmt
|
Returns a date format string, given a date
format style.
|
Date and Time
|
Decode
|
Returns the decoded version of a given string.
|
String
|
Encode
|
Returns the encoded version of a given string.
|
String
|
Eval
|
Returns the value of a given form calculation.
|
Miscellaneous
|
Exists
|
Determines whether the given parameter is
a reference syntax to an existing object.
|
Logical
|
Floor
|
Returns the largest whole number that is
less than or equal to the given value.
|
Arithmetic
|
Format
|
Formats the given data according to the
specified picture format string.
|
String
|
FV
|
Returns the future value of consistent payment
amounts made at regular intervals at a constant interest rate.
|
Financial
|
Get
|
Downloads the contents of the given URL.
|
URL
|
HasValue
|
Determines whether the given parameter is
an accessor with a non-null, non-empty, or non-blank value.
|
Logical
|
IPmt
|
Returns the amount of interest paid on a
loan over a set period of time.
|
Financial
|
IsoDate2Num
|
Returns the number of days since the Epoch,
given an valid date string.
|
Date and Time
|
IsoTime2Num
|
Returns the number of milliseconds since
the Epoch,
given a valid time string.
|
Date and Time
|
Left
|
Extracts a specified number of characters
from a string, starting with the first character on the left.
|
String
|
Len
|
Returns the number of characters in a given
string.
|
String
|
LocalDateFmt
|
Returns a localized date format string,
given a date format style.
|
Date and Time
|
LocalTimeFmt
|
Returns a localized time format string,
given a time format style.
|
Date and Time
|
Lower
|
Converts all uppercase characters within
a specified string to lowercase characters.
|
String
|
Ltrim
|
Returns a string with all leading white
space characters removed.
|
String
|
Max
|
Returns the maximum value of the non-null
elements in the given set of numbers.
|
Arithmetic
|
Min
|
Returns the minimum value of the non-null
elements of the given set of numbers.
|
Arithmetic
|
Mod
|
Returns the modulus of one number divided
by another.
|
Arithmetic
|
NPV
|
Returns the net present value of an investment
based on a discount rate and a series of periodic future cash flows.
|
Financial
|
Null
|
Returns the null value. The null value means
no value.
|
Miscellaneous
|
Num2Date
|
Returns a date string, given a number of
days since the Epoch.
|
Date and Time
|
Num2GMTime
|
Returns a GMT time string, given a number
of milliseconds from the Epoch.
|
Date and Time
|
Num2Time
|
Returns a time string, given a number of
milliseconds from the Epoch.
|
Date and Time
|
Oneof
|
Returns true (1) if a value is in a given
set, and false (0) if it is not.
|
Logical
|
Parse
|
Analyzes the given data according to the
given picture format.
|
String
|
Pmt
|
Returns the payment for a loan based on
constant payments and a constant interest rate.
|
Financial
|
Post
|
Posts the given data to the specified URL.
|
URL
|
PPmt
|
Returns the amount of principal paid on
a loan over a period of time.
|
Financial
|
Put
|
Uploads the given data to the specified
URL.
|
URL
|
PV
|
Returns the present value of an investment
of periodic constant payments at a constant interest rate.
|
Financial
|
Rate
|
Returns the compound interest rate per period
required for an investment to grow from present to future value
in a given period.
|
Financial
|
Ref
|
Returns a reference to an existing object.
|
Miscellaneous
|
Replace
|
Replaces all occurrences of one string with
another within a specified string.
|
String
|
Right
|
Extracts a number of characters from a given
string, beginning with the last character on the right.
|
String
|
Round
|
Evaluates a given numeric value or expression
and returns a number rounded to the given number of decimal places.
|
Arithmetic
|
Rtrim
|
Returns a string with all trailing white
space characters removed.
|
String
|
Space
|
Returns a string consisting of a given number
of blank spaces.
|
String
|
Str
|
Converts a number to a character string.
FormCalc formats the result to the specified width and rounds to
the specified number of decimal places.
|
String
|
Stuff
|
Inserts a string into another string.
|
String
|
Substr
|
Extracts a portion of a given string.
|
String
|
Sum
|
Returns the sum of the non-null elements
of a given set of numbers.
|
Arithmetic
|
Term
|
Returns the number of periods needed to
reach a given future value from periodic constant payments into
an interest-bearing account.
|
Financial
|
Time
|
Returns the current system time as the number
of milliseconds since the Epoch.
|
Date and Time
|
Time2Num
|
Returns the number of milliseconds since
the Epoch,
given a time string.
|
Date and Time
|
TimeFmt
|
Returns a time format, given a time format
style.
|
Date and Time
|
UnitType
|
Returns the units of a unitspan. A unitspan
is a string consisting of a number followed by a unit name.
|
Miscellaneous
|
UnitValue
|
Returns the numeric value of a measurement
with its associated unitspan, after an optional unit conversion.
|
Miscellaneous
|
Upper
|
Converts all lowercase characters within
a string to uppercase.
|
String
|
Uuid
|
Returns a Universally Unique Identifier
(UUID) string to use as an identification method.
|
String
|
Within
|
Returns true (1) if the test value is within
a given range, and false (0) if it is not.
|
Logical
|
WordNum
|
Returns the English text equivalent of a
given number.
|
String
|
