Function
|
Returns
|
|
Abs
|
The absolute value of a number.
|
|
Array
|
A variant containing an array.
|
|
Asc
|
The ASCII character code of a character or the first character of a string.
|
|
Atn
|
The Arc tangent of a number.
|
|
Cbool
|
The Boolean value of an expression passed into the function.
|
|
Cbyte
|
A number of type byte, converted from a number passed into the function.
|
|
Cdate
|
A date type, converted from a valid date expression passed into the function.
|
|
CDbl
|
A variant of subtype double from an expression passed into the function.
|
|
Chr
|
The ASCII character of an ASCII code.
|
|
Cint
|
A variant of subtype Integer from an expression passed into the function.
|
|
CLng
|
A variant of subtype long after the expression passed into the function is converted into long.
|
|
Cos
|
The cosine of an angle.
|
|
CSng
|
A variant of subtype Single from a numerical expression.
|
|
CStr
|
A string from an expression.
|
|
CVErr
|
A user specified error code.
|
|
Date
|
The date from the system clock.
|
|
DateSerial
|
Calculations of various days based on current date.
|
|
DateValue
|
A variant of subtype date.
|
|
Day
|
A value between 1 and 31 and can be used to find the day of a date.
|
|
Exp
|
The value of e raised to a power.
|
|
Hex
|
The hexadecimal (base 16) value of a numerical expression.
|
|
Hour
|
The number of hours of a time expression.
|
|
InputBox
|
A dialog box prompt.
|
|
InStr
|
The location of one string in another string.
|
|
Int, Fix
|
Integers from numerical expressions.
|
|
IsArray
|
True if a variable is an array and False otherwise.
|
|
IsDate
|
True if an expression can be converted to a valid date and False otherwise.
|
|
IsEmpty
|
True if a variable has been initialized and False otherwise.
|
|
IsError
|
True if an expression is an error code and False otherwise.
|
|
IsNull
|
True if an expression is NULL and False otherwise.
|
|
IsNumeric
|
True if an expression is numeric and False otherwise.
|
|
IsObject
|
True if an expression references an OLE Automation Object and False otherwise.
|
|
Lbound
|
The minimum index of an array dimension.
|
|
Lcase
|
The lowercase value of a string expression.
|
|
Left
|
A certain number of characters from the left side of a string.
|
|
Len
|
The number of characters of a string expression.
|
|
Log
|
The natural logarithm of a nonnegative numerical expression.
|
|
Ltrim
|
String after eliminating preceding spaces.
|
|
Mid
|
A certain number of characters from a string.
|
|
Minute
|
The number of minutes when called with the time.
|
|
Month
|
The month when called with a date.
|
|
MsgBox
|
A message box.
|
|
Now
|
The current date and time from the system clock.
|
|
Oct
|
The octal value (base 8) of a numerical expression.
|
|
Right
|
A certain number of characters from the right side of a string.
|
|
Rnd
|
A random number between 1 and 0.
|
|
Rtrim
|
String after eliminating trailing spaces.
|
|
Second
|
The number of seconds of a date expression.
|
|
Sgn
|
The sign of a numerical expression.
|
|
Sin
|
The Sine of an angle.
|
|
Sqr
|
The square root of a nonnegative numerical expression.
|
|
Str
|
A string converted from a numerical expression.
|
|
StrComp
|
The values of a string comparison.
|
|
String
|
A character value repeated N times.
|
|
Tan
|
The tangent of an angle.
|
|
Time
|
The current time from the system clock.
|
|
TimeSerial
|
Time calculations based on current time.
|
|
TimeValue
|
Expression passed into the function after converting it into a variant of subtype Date.
|
|
Trim
|
String after eliminating both trailing and preceding spaces.
|
|
Ubound
|
The maximum size of an array dimension.
|
|
Ucase
|
The uppercase value of a string expression.
|
|
Val
|
A number contained in a string.
|
|
VarType
|
The type of a variable.
|
|
Weekday
|
A number between 1 and 7, for days of a week.
|
|
Year
|
The year of the expression. |
For more information on VBScript, turn to Chapter 12, "Unleashing the Power of VBScript."