Function
|
Description
|
Abs
|
Returns the absolute value of a number
|
Array
|
Returns an array.
|
Asc
|
Returns the ASNI character code corresponding to the first letter in a string.
|
Atn
|
Returns the arctangent of a number.
|
CBool
|
Returns an expression that has been converted to a Boolean variant.
|
CByte
|
Returns an expression that has been converted to a Byte variant.
|
CCur
|
Returns an expression that has been converted to Currency variant.
|
CDate
|
Returns an expression that has been converted to a Date variant.
|
CDbl
|
Returns an expression that has been converted to a Double variant.
|
Chr
|
Returns the character associated with the specified ANSI character code.
|
CInt
|
Returns an expression that has been converted to an Integer variant.
|
CLng
|
Returns an expression that has been converted to a Long variant.
|
Cos
|
Returns the cosine of an angle.
|
CreateObject
|
Creates and returns a reference to an Automation object.
|
CSng
|
Returns an object that has been converted to a Single variant.
|
CStr
|
Returns an expression that has been converted to a String variant.
|
Date
|
Returns the current system date.
|
DateAdd
|
Returns a date to which a specified time interval has been added.
|
DateDiff
|
Returns the number of intervals between two dates.
|
DatePart
|
Returns the specified part of a given date.
|
DateSerial
|
Returns a Date variant for a specified year, month and day.
|
DateValue
|
Returns a Date variant.
|
Day
|
Returns the day of the month (1-31).
|
Exp
|
Returns e raised to a power.
|
Filter
|
Returns a subset of a string array based on a specified filter criteria.
|
Fix
|
Returns the integer portion of a number.
|
FormatCurrency
|
Returns an expression formatted as a currency value.
|
FormatDateTime
|
Returns an expression formatted as a date or time.
|
FormatNumber
|
Returns an expression formatted as a number.
|
FormatPercent
|
Returns an expression formatted as a percentage.
|
GetObject
|
Returns a reference to an Automation object from a file. Windows NT systems only.
|
Hex
|
Returns a string representing the hexadecimal value of a number.
|
Hour
|
Returns the hour of the day (0-23).
|
InputBox
|
Displays a prompt in a dialog box. Client-side only.
|
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, working from the end of the string.
|
Int
|
Returns the integer portion of a number.
|
IsArray
|
Returns a Boolean value indicating whether a variable is an array.
|
IsDate
|
Returns a Boolean value indicating whether an expression can be converted to a date..
|
IsEmpty
|
Returns a Boolean value indicating whether a variable has been initialized.
|
IsNull
|
Returns a Boolean value indicating whether an expression contains no valid data (Null).
|
IsNumeric
|
Returns a Boolean value indicating whether an expression can be evaluated as a number.
|
IsObject
|
Returns a Boolean value indicating whether an expression references a valid object.
|
Join
|
Returns a string created by joining a number of substrings contained in an array.
|
LBound
|
Returns the smallest available subscript for the indicated dimension of an array.
|
LCase
|
Returns a string that has been converted to lower case.
|
Left
|
Returns a specified number of characters from the left side of a string.
|
Len
|
Returns the number of characters in a string or the number of bytes required to store a variable.
|
LoadPicture
|
Returns a picture object.
|
Log
|
Returns the natural logarithm of a number.
|
LTrim
|
Returns a copy of a string without leading spaces.
|
Mid
|
Returns a specified number of characters from a string.
|
Minute
|
Returns the minute of the hour (0-59)
|
Month
|
Returns the number of the month (1-12)
|
MonthName
|
Returns a string with the name of the specified month.
|
MsgBox
|
Displays a message in a dialog box. Client-side only.
|
Now
|
Returns the current date and time set on your computer system.
|
Oct
|
Returns a string representing the octal value of a number.
|
Replace
|
Returns a string in which a specified substring has been replaced with another substring a specified number of times.
|
RGB
|
Returns a whole number representing an RGB color value.
|
Right
|
Returns a specified number of characters from the right side of a string.
|
Rnd
|
Returns a random number.
|
Round
|
Returns a number rounded to a specified number of decimal places.
|
RTrim
|
Returns a copy of a string without trailing spaces.
|
ScriptEngine
|
Returns a string containing the scripting language in use.
|
ScriptEngineBuildVersion
|
Returns the build version number of the script engine in use.
|
ScriptEngineMajorVersion
|
Returns the major version number of the script engine in use.
|
ScriptEngineMinorVersion
|
Returns the minor version number of the script engine in use.
|
Second
|
Returns the second (0-59).
|
Sgn
|
Returns an integer indicating the sign of a number.
|
Sin
|
Returns the sine of an angle.
|
Space
|
Returns a string consisting of the specified number of spaces.
|
Split
|
Returns an array containing a specified number of substrings.
|
Sqr
|
Returns the square root of a number.
|
StrComp
|
Returns a value indicating the result of a string comparison.
|
StrReverse
|
Returns a string in which the character order of a specified string is reversed.
|
String
|
Returns a repeating character string of the length specified.
|
Tan
|
Returns the tangent of an angle.
|
FormatDateTime
|
Returns a Date variant with the current system time.
|
TimeSerial
|
Returns a Date variant with the time for a specific hour, minute, and second.
|
TimeValue
|
Returns a Date variant containing the time.
|
Trim
|
Returns a copy of a string without leading or trailing spaces.
|
TypeName
|
Returns a string that provides Variant subtype information about a variable.
|
UBound
|
Returns the largest available subscript for the indicated dimension of an array.
|
UCase
|
Returns a string that has been converted to upper case.
|
VarType
|
Returns a value indicating the subtype of a variable.
|
Weekday
|
Returns a whole number representing the day of the week.
|
WeekdayName
|
Returns a string containing the specific day of the week.
|
Year
|
Returns a whole number containing the year.
|