Function Reference

The functions available in expressions are organized in several categories, based on their purpose. Some functions belong to more than one category. Below is a table of all functions sorted alphabetically.

Name
Description
Abs
Returns the absolute value of a specified number.
Acos
Returns the angle whose cosine is the specified number.
Asc
Returns the ANSI character code corresponding to the first letter in a string.
Asin
Returns the angle whose sine is the specified number.
Atn
Returns the angle whose tangent is the specified number.
CBool
Converts the value, specified as an argument, to a value of type Boolean.
CDate
Converts the value, specified as an argument, to a value of type Date.
CDbl
Converts the value, specified as an argument, to a value of type Double.
Chr
Returns the character associated with the specified ANSI character code.
CInt
Converts the value, specified as an argument, to a value of type Integer.
CLong
Converts the value, specified as an argument, to a value of type Long.
Cos
Returns the cosine of an angle.
CStr
Converts the value, specified as an argument, to a value of type String.
CSng
Converts the value, specified as an argument, to a value of type float.
DateAdd
Returns a date to which a specified time interval has been added.
DatePart
Returns the specified part of a given date.
Day
Returns a whole number between 1 and 31, inclusive, representing the day of the month.
DateDiff
Returns the number of intervals between two dates.
DateSerial
Returns a value of type Date for a specified year, month, and day.
E
Represents the natural logarithmic base, specified by the constant, e.
Exp
Returns e raised to the specified power.
Hour
Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
IIf
Returns one of two parts, depending on the evaluation of an expression.
InStr
Returns the position of the first occurrence of one string within another.
InStrRev
Returns the position of an occurrence of one string within another, from the end of string.
Int
Returns the integer portion of a number.
IsDate
Returns a Boolean value indicating whether an expression can be converted to a date.
IsNull
Returns a Boolean value that indicates whether an expression contains no valid data (Null).
IsNumeric
Returns a Boolean value indicating whether an expression can be evaluated as a number.
LCase
Returns a string that has been converted to lowercase.
Left
Returns a specified number of characters from the left side of a string.
Len
Returns the number of characters in a string.
Log
Returns the logarithm of a specified number.
LTrim
Returns a copy of a string without leading spaces.
Mid
Returns a specified number of characters from a string.
Minute
Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
Month
Returns a whole number between 1 and 12, inclusive, representing the month of the year.
Now
Returns the current date and time according to the setting of your computer's system date and time.
PageCount
Returns the number of pages.
PageCurrent
Returns the number of the current page.
PI
Represents the ratio of the circumference of a circle to its diameter.
Pow
Returns a specified number raised to the specified power.
RangeItemCount
Returns the count of the items in the current DataRange.
RangeItemCurrent
Returns a number that is the index of the current instance of the DataRange.
Replace
Returns a string in which a specified substring has been replaced with another substring a specified number of times.
Right
Returns a specified number of characters from the right side of a string.
Rnd
Returns a random number.
Round
Returns the number nearest the specified value.
RTrim
Returns a copy of a string without trailing spaces.
Second
Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
Sgn
Returns a value indicating the sign of a number.
Sin
Returns the sine of the specified angle.
Space
Returns a string consisting of the specified number of spaces.
Sqr
Returns the square root of a number.
Sqrt
Returns the square root of a number.
Str
Returns a string representation of a number.
StrComp
Returns a value indicating the result of a string comparison.
String
Returns a repeating character string of the length specified.
StrReverse
Returns a string in which the character order of a specified string is reversed.
Today
Returns a DateTime value containing the current date according to your system.
Tan
Returns the tangent of the specified angle.

	Name	Description
	Abs	Returns the absolute value of a specified number.
	Acos	Returns the angle whose cosine is the specified number.
	Asc	Returns the ANSI character code corresponding to the first letter in a string.
	Asin	Returns the angle whose sine is the specified number.
	Atn	Returns the angle whose tangent is the specified number.
	CBool	Converts the value, specified as an argument, to a value of type Boolean.
	CDate	Converts the value, specified as an argument, to a value of type Date.
	CDbl	Converts the value, specified as an argument, to a value of type Double.
	Chr	Returns the character associated with the specified ANSI character code.
	CInt	Converts the value, specified as an argument, to a value of type Integer.
	CLong	Converts the value, specified as an argument, to a value of type Long.
	Cos	Returns the cosine of an angle.
	CStr	Converts the value, specified as an argument, to a value of type String.
	CSng	Converts the value, specified as an argument, to a value of type float.
	DateAdd	Returns a date to which a specified time interval has been added.
	DatePart	Returns the specified part of a given date.
	Day	Returns a whole number between 1 and 31, inclusive, representing the day of the month.
	DateDiff	Returns the number of intervals between two dates.
	DateSerial	Returns a value of type Date for a specified year, month, and day.
	E	Represents the natural logarithmic base, specified by the constant, e.
	Exp	Returns e raised to the specified power.
	Hour	Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
	IIf	Returns one of two parts, depending on the evaluation of an expression.
	InStr	Returns the position of the first occurrence of one string within another.
	InStrRev	Returns the position of an occurrence of one string within another, from the end of string.
	Int	Returns the integer portion of a number.
	IsDate	Returns a Boolean value indicating whether an expression can be converted to a date.
	IsNull	Returns a Boolean value that indicates whether an expression contains no valid data (Null).
	IsNumeric	Returns a Boolean value indicating whether an expression can be evaluated as a number.
	LCase	Returns a string that has been converted to lowercase.
	Left	Returns a specified number of characters from the left side of a string.
	Len	Returns the number of characters in a string.
	Log	Returns the logarithm of a specified number.
	LTrim	Returns a copy of a string without leading spaces.
	Mid	Returns a specified number of characters from a string.
	Minute	Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
	Month	Returns a whole number between 1 and 12, inclusive, representing the month of the year.
	Now	Returns the current date and time according to the setting of your computer's system date and time.
	PageCount	Returns the number of pages.
	PageCurrent	Returns the number of the current page.
	PI	Represents the ratio of the circumference of a circle to its diameter.
	Pow	Returns a specified number raised to the specified power.
	RangeItemCount	Returns the count of the items in the current DataRange.
	RangeItemCurrent	Returns a number that is the index of the current instance of the DataRange.
	Replace	Returns a string in which a specified substring has been replaced with another substring a specified number of times.
	Right	Returns a specified number of characters from the right side of a string.
	Rnd	Returns a random number.
	Round	Returns the number nearest the specified value.
	RTrim	Returns a copy of a string without trailing spaces.
	Second	Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
	Sgn	Returns a value indicating the sign of a number.
	Sin	Returns the sine of the specified angle.
	Space	Returns a string consisting of the specified number of spaces.
	Sqr	Returns the square root of a number.
	Sqrt	Returns the square root of a number.
	Str	Returns a string representation of a number.
	StrComp	Returns a value indicating the result of a string comparison.
	String	Returns a repeating character string of the length specified.
	StrReverse	Returns a string in which the character order of a specified string is reversed.
	Today	Returns a DateTime value containing the current date according to your system.
	Tan	Returns the tangent of the specified angle.