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