Easy Tutorial
❮ Func Instr Func Weekdayname ❯

VBScript Functions

This page lists all built-in VBScript functions, primarily categorized as follows:

| Date/Time Functions<br> Conversion Functions<br> Format Functions | Math Functions<br> Array Functions | String Functions<br> Other Functions |

Date/Time Functions

Function Description
CDate Converts a valid date and time expression to the Date type.
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 the date for a specified year, month, and day.
DateValue Returns a date.
Day Returns a number representing the day of the month (between and including 1 and 31).
FormatDateTime Returns an expression formatted as a date or time.
Hour Returns a number representing the hour of the day (between and including 0 and 23).
IsDate Returns a Boolean value indicating whether an expression can be converted to a date.
Minute Returns a number representing the minute of the hour (between and including 0 and 59).
Month Returns a number representing the month of the year (between and including 1 and 12).
MonthName Returns the name of the specified month.
Now Returns the current system date and time.
Second Returns a number representing the second of the minute (between and including 0 and 59).
Time Returns the current system time.
Timer Returns the number of seconds since 12:00 AM.
TimeSerial Returns the time for a specific hour, minute, and second.
TimeValue Returns a time.
Weekday Returns a number representing the day of the week (between and including 1 and 7).
WeekdayName Returns the name of the specified day of the week.
Year Returns a number representing the year.

| Conversion Functions | Top |

Function Description
Asc Converts the first letter in a string to its ANSI character code.
CBool Converts an expression to the Boolean type.
CByte Converts an expression to the Byte type.
CCur Converts an expression to the Currency type.
CDate Converts a valid date and time expression to the Date type.
CDbl Converts an expression to the Double type.
Chr Converts the specified ANSI character code to a character.
CInt Converts an expression to the Integer type.
CLng Converts an expression to the Long type.
CSng Converts an expression to a Single precision type.
CStr Converts an expression to a String type.
Hex Returns the hexadecimal value of a specified number.
Oct Returns the octal value of a specified number.

| Format Function | Top |

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 percentage.

| Math Functions | Top |

Function Description
Abs Returns the absolute value of a specified number.
Atn Returns the arctangent of a specified number.
Cos Returns the cosine of a specified number (angle).
Exp Returns e (the base of natural logarithms) raised to a power.
Hex Returns the hexadecimal value of a specified number.
Int Returns the integer part of a specified number.
Fix Returns the integer part of a specified number.
Log Returns the natural logarithm of a specified number.
Oct Returns the octal value of a specified number.
Rnd Returns a random number less than 1 but greater than or equal to 0.
Sgn Returns an integer indicating the sign of a specified number.
Sin Returns the sine of a specified number (angle).
Sqr Returns the square root of a specified number.
Tan Returns the tangent of a specified number (angle).

| Array Functions | Top |

Function Description
Array Returns a variable containing an array.
Filter Returns a zero-based array containing a subset of a string array based on a specified filter criteria.
IsArray Returns a Boolean value indicating whether a specified variable is an array.
Join Returns a string consisting of a number of substrings in an array.
LBound Returns the smallest subscript for the indicated dimension of an array.
Split Returns a one-dimensional array containing a specified number of substrings.
UBound Returns the largest subscript for the indicated dimension of an array.

| String Functions | Top |

Function Description
InStr Returns the position of the first occurrence of one string within another. The search begins at the first character of the string.
InStrRev Returns the position of the first occurrence of one string within another. The search begins at the last character of the string.
LCase Converts the specified string 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.
LTrim Removes spaces on the left side of a string.
RTrim Removes spaces on the right side of a string.
Trim Removes spaces on both the left and right sides of a string.
Mid Returns a specified number of characters from a string.
Replace Replaces a specified part of a string with another string 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 a specified number of spaces.
StrComp Compares two strings and returns a value that represents the result of the comparison.
String Returns a string consisting of a specified length of repeated characters.
StrReverse Reverses a string.
UCase Converts a specified string to uppercase.

| Other Functions | Top |

Function Description
CreateObject Creates an object of a specified type.
Eval Evaluates an expression and returns the result.
GetLocale Returns the current locale ID.
GetObject Returns a reference to an automation object from a file.
GetRef Allows you to connect a VBScript subroutine to a DHTML event on the page.
InputBox Displays a dialog box where the user can enter text and/or click a button, then returns the content.
IsEmpty Returns a Boolean value indicating whether a specified variable has been initialized.
IsNull Returns a Boolean value indicating whether a specified expression contains invalid data (Null).
IsNumeric Returns a Boolean value indicating whether a specified expression can be evaluated as a number.
IsObject Returns a Boolean value indicating whether a specified expression is an automation object.
LoadPicture Returns a picture object. Only for 32-bit platforms.
MsgBox Displays a message box, waits for the user to click a button, and returns a value indicating which button the user clicked.
RGB Returns a number representing an RGB color value.
Round Rounds a number to the nearest integer.
ScriptEngine Returns the scripting language in use.
ScriptEngineBuildVersion Returns the build version number of the scripting engine in use.
ScriptEngineMajorVersion Returns the major version number of the scripting engine in use.
ScriptEngineMinorVersion Returns the minor version number of the scripting engine in use.
SetLocale Sets the locale ID and returns the previous locale ID.
TypeName Returns the subtype of a specified variable.
VarType Returns a value indicating the subtype of a variable.
❮ Func Instr Func Weekdayname ❯