VBScript Functions

Language Element	Description
Abs Function	Occurs when an instance of the associated class is terminated.
Array Function	Returns a Variant containing an array.
Asc Function	Returns the ANSI character code corresponding to the first letter in a string.
Atn Function	Returns the arctangent of a number.
CBool Function	Returns an expression that has been converted to a Variant of subtype Boolean.
CByte Function	Returns an expression that has been converted to a Variant of subtype Byte.
CCur Function	Returns an expression that has been converted to a Variant of subtype Currency.
CDate Function	Returns an expression that has been converted to a Variant of subtype Date.
CDbl Function	Returns an expression that has been converted to a Variant of subtype Double.
Chr Function	Returns the character associated with the specified ANSI character code.
CInt Function	Returns an expression that has been converted to a Variant of subtype Integer.
CLng Function	Returns an expression that has been converted to a Variant of subtype Long.
Cos Function	Returns the cosine of an angle.
CreateObject Function	Creates and returns a reference to an Automation object.
CSng Function	Returns an expression that has been converted to a Variant of subtype Single.
CStr Function	Returns an expression that has been converted to a Variant of subtype String.
Date Function	Returns the current system date.
DateAdd Function	Returns a date to which a specified time interval has been added.
DateDiff Function	Returns the number of intervals between two dates.
DatePart Function	Returns the specified part of a given date.
DateSerial Function	Returns a Variant of subtype Date for a specified year, month, and day.
DateValue Function	Returns a Variant of subtype Date.
Day Function	Returns a whole number between 1 and 31, inclusive, representing the day of the month.
Eval Function	Evaluates an expression and returns the result.
Exp Function	Returns e (the base of natural logarithms) raised to a power.
Filter Function	Returns a zero-based array containing subset of a string array based on a specified filter criteria.
Fix Function	Returns the integer portion of a number.
FormatCurrency Function	Returns an expression formatted as a currency value using the currency symbol defined in the system control panel.
FormatDateTime Function	Returns an expression formatted as a date or time.
FormatNumber Function	Returns an expression formatted as a number.
FormatPercent Function	Returns an expression formatted as a percentage (multiplied by 100) with a trailing % character.
GetLocale Function	Returns the current locale ID value.
GetObject Function	Returns a reference to an Automation object from a file.
GetRef Function	Returns a reference to a procedure that can be bound to an event.
Hex Function	Returns a string representing the hexadecimal value of a number.
Hour Function	Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
InputBox Function	Displays a prompt in a dialog box, waits for the user to input text or click a button, and returns the contents of the text box.
InStr Function	Returns the position of the first occurrence of one string within another.
InStrRev Function	Returns the position of an occurrence of one string within another, from the end of string.
Int Function	Returns the integer portion of a number.
IsArray Function	Returns a Boolean value indicating whether a variable is an array.
IsDate Function	Returns a Boolean value indicating whether an expression can be converted to a date.
IsEmpty Function	Returns a Boolean value indicating whether a variable has been initialized.
IsNull Function	Returns a Boolean value that indicates whether an expression contains no valid data (Null).
IsNumeric Function	Returns a Boolean value indicating whether an expression can be evaluated as a number.
IsObject Function	Returns a Boolean value indicating whether an expression references a valid Automation object.
Join Function	Returns a string created by joining a number of substrings contained in an array.
LBound Function	Returns the smallest available subscript for the indicated dimension of an array.
LCase Function	Returns a string that has been converted to lowercase.
Left Function	Returns a specified number of characters from the left side of a string.
Len Function	Returns the number of characters in a string or the number of bytes required to store a variable.
LoadPicture Function	Returns a picture object. Available only on 32-bit platforms.
Log Function	Returns the natural logarithm of a number.
LTrim Function	Returns a copy of a string without leading spaces.
Mid Function	Returns a specified number of characters from a string.
Minute Function	Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
Month Function	Returns a whole number between 1 and 12, inclusive, representing the month of the year.
MonthName Function	Returns a string indicating the specified month.
MsgBox Function	Displays a message in a dialog box, waits for the user to click a button, and returns a value indicating which button the user clicked.
Now Function	Returns the current date and time according to the setting of your computer's system date and time.
Oct Function	Returns a string representing the octal value of a number.
Replace Function	Returns a string in which a specified substring has been replaced with another substring a specified number of times.
RGB Function	Returns a whole number representing an RGB color value.
Right Function	Returns a specified number of characters from the right side of a string.
Rnd Function	Returns a random number.
Round Function	Returns a number rounded to a specified number of decimal places.
RTrim Function	Returns a copy of a string without trailing spaces.
ScriptEngine Function	Returns a string representing the scripting language in use.
ScriptEngineBuildVersion Function	Returns the build version number of the scripting engine in use.
ScriptEngineMajorVersion Function	Returns the major version number of the scripting engine in use.
ScriptEngineMinorVersion Function	Returns the minor version number of the scripting engine in use.
Second Function	Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
Sgn Function	Returns an integer indicating the sign of a number.
Sin Function	Returns the sine of an angle.
Space Function	Returns a string consisting of the specified number of spaces.
Split Function	Returns a zero-based, one-dimensional array containing a specified number of substrings.
Sqr Function	Returns the square root of a number.
StrComp Function	Returns a value indicating the result of a string comparison.
String Function	Returns a repeating character string of the length specified.
StrReverse Function	Returns a string in which the character order of a specified string is reversed.
Tan Function	Returns the tangent of an angle.
Time Function	Returns a Variant of subtype Date indicating the current system time.
Timer Function	Returns the number of seconds that have elapsed since 12:00 AM (midnight).
TimeSerial Function	Returns a Variant of subtype Date containing the time for a specific hour, minute, and second.
TimeValue Function	Returns a Variant of subtype Date containing the time.
Trim Function	Returns a copy of a string without leading or trailing spaces.
TypeName Function	Returns a string that provides Variant subtype information about a variable.
UBound Function	Returns the largest available subscript for the indicated dimension of an array.
UCase Function	Returns a string that has been converted to uppercase.
VarType Function	Returns a value indicating the subtype of a variable.
Weekday Function	Returns a whole number representing the day of the week.
WeekdayName Function	Returns a string indicating the specified day of the week.
Year Function	Returns a whole number representing the year.