This page will provide you with a quick look at the more important VBScript functions. They include functions for type checking, date manipulation, string manipulation, formatting, math, and more.
Function |
Description |
VarType |
Returns an integer code that indicates the subtype of a variable. |
TypeName |
Returns the subtype of a variable. |
IsNumeric |
Returns a Boolean value indicating whether an expression can be evaluated as a number. |
IsArray |
Returns a Boolean value indicating whether a variable is an array. |
IsDate |
Returns a Boolean value indicating whether the expression can be converted to a date. |
IsEmpty |
Returns a Boolean value indicating whether a variable has been initialized or not. |
IsNull |
Returns a Boolean value that indicates whether an expression contains no valid datatype. |
IsObject |
Returns a Boolean value indicating whether an expression refers to an Automation object. |
Function |
Description |
CBool |
Converts an expression to a Boolean subtype. |
CByte |
Converts an expression to a Byte subtype. |
CCur |
Converts an expression to a Currency subtype. |
CDate |
Converts an expression to a Date subtype. |
CDbl |
Converts an expression to a Double subtype. |
CInt |
Converts an expression to a Integer subtype. |
CLng |
Converts an expression to a Long subtype. |
CSng |
Converts an expression to a Single subtype. |
CStr |
Converts an expression to a String subtype. |
Function |
Description |
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 percent value with a trailing percent (%) symbol. |
Function |
Description |
Join |
Returns a string created by joining strings stored in an array. |
Filter |
Returns a zero-based array containing subset of a string array based on a filter criteria. |
InStr |
Returns the numeric position of the first occurrence of one string within another. |
InStrRev |
Returns the numeric position of the first occurrence of one string within another starting from the end of the string. |
LCase |
Returns a string with all its uppercase letters converted to lowercase letters. |
Left |
Returns a specified number of characters from the left side of a string. |
Len |
Returns the number of characters in a string. |
LTrim |
Removes all the spaces from the left side of a string. |
RTrim |
Removes all the spaces from the right side of a string. |
Trim |
Removes spaces from both the left and the right sides of a string. |
Mid |
Returns a specified number of characters from a string. |
Replace |
Returns a string in which a specified sub-string 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. |
Space |
Returns a string consisting of the number of defined spaces. |
Split |
Returns a zero-based, one-dimensional array that contains a specified number of substrings. |
StrComp |
Compares two strings and returns a value indicating the result of the comparison. |
String |
Returns a string consisting of character repeated number times. |
StrReverse |
Returns a string where the character order has been reversed. |
UCase |
Returns string with all its lowercase letters converted to uppercase letters. |
Function |
Description |
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 for a specified year, month, and day. |
DateValue |
Returns a date. |
Day |
Returns a number representing the day of the month (between 1 and 31, inclusive). |
Hour |
Returns a number representing the hour of the day (between 0 and 23, inclusive). |
Minute |
Returns a number of the minutes in current system time (between 0 and 59, inclusive). |
Month |
Returns a number representing the month of the year (between 1 and 12, inclusive). |
MonthName |
Returns the name of a specified month. |
Now |
Returns the current system date and time. |
Second |
Returns the current seconds value of the current system time (between 0 and 59, inclusive). |
Time |
Returns the current system time. |
TimeSerial |
Returns the time for a specific hour, minute, and second. |
TimeValue |
Returns the current system time. |
Weekday |
Returns a number representing the day of the week (between 1 and 7, inclusive). |
WeekdayName |
Returns the weekday name of a specified day of the week. |
Year |
Returns a number representing the year. |
Function |
Description |
Abs |
Returns the absolute value of a number. |
Atn |
Returns the arctangent of a number. |
Cos |
Returns the cosine of an angle. |
Exp |
Returns e, the base of natural logarithms, raised to a power. |
Hex |
Returns a string representing the hexadecimal value of a number. |
Int |
Returns the integer portion of a number. If number is negative, Int returns the first integer less than or equal to number. |
Fix |
Returns the integer portion of a number. If number is negative, Fix returns the first integer greater than or equal to number. |
Log |
Returns the natural logarithm of a number. |
Oct |
Returns a string representing the octal value of a number. |
Rnd |
Returns a random number less than 1 but greater or equal to 0. |
Round |
Returns a number rounded to a specified number of decimal places. |
Sgn |
Returns an integer indicating the sign of a number. |
Sin |
Returns the sine of an angle. |
Sqr |
Returns the square root of a number. |
Tan |
Returns the tangent of an angle. |
Function |
Description |
Chr |
Returns the character specified by the ANSI character code. |
Array |
Returns an array containing the specified values. |
Asc |
Returns the ANSI character code of a string. |
LBound |
Returns the lower limit for the elements in an array. |
UBound |
Returns the upper limit for the number of elements in an array. | |