VBscript Built-in Functions
 

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