VBScript Functions

Predefined Function

Table of VBScript language function features

NameDescriptionVersionReviewAbs FunctionCreate an unsigned magnitude, or the absolute value of a given number.1last updated 16 Sep 2017Array FunctionCreate a zero-based one-dimensional array from a given comma-delimited list of values by arranging the elements of the ordered list as members of the array.2last updated 16 Sep 2017Asc FunctionCreate an ANSI character code number from the first character of a given string by encoding the first character of the given string as the associated ANSI character of the ANSI character code.1last updated 16 Sep 2017AscB FunctionCreate a Byte from the first byte of the character code of first character of a given string.1last updated 16 Sep 2017AscW FunctionCreate a decimal Unicode (wide) character code from the character code of first character of a given string.1last updated 16 Sep 2017Atn FunctionConverts a given number to an angle in radian by taking the inverse trigonometric function of tangent function of the given number.1last updated 16 Sep 2017CBool FunctionCreate a Boolean result value of a given expression.1last updated 16 Sep 2017CByte FunctionCreate a Byte data subtype value from a given expression.1last updated 16 Sep 2017CCur FunctionCreate a Currency data subtype value from a given expression.1last updated 16 Sep 2017CDate FunctionCreate a Date data subtype value from a given expression.1last updated 16 Sep 2017CDbl FunctionCreate a Double data subtype value from a given expression.1last updated 16 Sep 2017Chr FunctionCreate an ANSI character string from a given charcode by evaluating the given charcode as the ANSI character code of the associated character.1last updated 16 Sep 2017ChrB FunctionCreate a character string from a given charcode by evaluating the given charcode as the Byte code of the associated character.1last updated 16 Sep 2017ChrW FunctionCreate a character string from a given charcode by evaluating the given charcode as the Unicode (wide) character code or Unicode/DBCS of the associated Unicode character.1last updated 16 Sep 2017CInt FunctionCreate an Integer data subtype value from a given expression.1last updated 17 Sep 2017CLng FunctionCreate a Long data subtype value from a given expression.1last updated 17 Sep 2017Cos FunctionConverts a given number to the cosine of the given number by taking the given number as an angle in radian.1last updated 17 Sep 2017CreateObject FunctionCreate a reference to an automation object specified by servername and typename arguments of the object on a location according to the location argument.2last updated 17 Sep 2017CSng FunctionCreate a Single data subtype value from a given expression.1last updated 17 Sep 2017CStr FunctionCreate a String data subtype value from a given expression.1last updated 17 Sep 2017Date FunctionCreate a date part of the date from the current date of a local computer system with format according to the date setting of the local computer system.1last updated 17 Sep 2017DateAdd FunctionCreate a date from a given date by adding the specified number of interval to the given date.2last updated 17 Sep 2017DateDiff FunctionCreate a number from two given dates by counting the specified interval from date1 to date2 according to firstdayofweek and firstweekofyear setting.2last updated 18 Sep 2017DatePart FunctionCreate a Integer from a given valid Date expression according the the specified interval argument, and firstdayofweek and firstweekofyear settings.2last updated 18 Sep 2017DateSerial FunctionCreate a date from given numeric expressions of year, month, and day.1last updated 18 Sep 2017DateValue FunctionCreate a date part of date from a given acceptable date string.1last updated 18 Sep 2017Day FunctionCreate an Integer with value between 1 and 31 inclusive for representing the 31 days of a month respectively from a given date expression by getting the day part of the given date expression.1last updated 18 Sep 2017Escape FunctionCreate a String from a given charString by encodeing the unallowable characters of the given charString by the correpsonding character code. While the allowable characters, i.e. *, +, -, ., 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, @, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, _, a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z, of the given charString remains unchanged.5last updated 18 Sep 2017Eval FunctionCreate a evaluation result from a given expression.5last updated 18 Sep 2017Exp FunctionConverts a given number to the base of natural logarithms, e, raised to a power of the given number.1last updated 18 Sep 2017Filter FunctionCreate a zero-based array by filtering a given InputStrings according to the specified search Value, and the specified Include and Compare settings.2last updated 18 Sep 2017Fix FunctionCreate an integer value of a given number that is equal to the integer part of the given number by removing the fractional part or non-integer part of the given number.1last updated 19 Sep 2017FormatCurrency FunctionCreate a string of a formatted currency value expression with a currency symbol defined in the local computer's regional settings from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.2last updated 18 Sep 2017FormatDateTime FunctionCreate a string of a formatted date or time value expression from a given date or is evaluated as date expression according to local system settings and specified arguments.2last updated 18 Sep 2017FormatNumber FunctionCreate a string of a formatted number value expression from a given numeric or is evaluated as numeric expression according to local system settings and specified arguments.2last updated 18 Sep 2017FormatPercent FunctionCreate a string of a formatted percentage value expression from a given numeric or is evaluated as numeric expression by multiplying the numeric value with 100 and adding a trailing % character according to local system settings and specified arguments.2last updated 19 Sep 2017GetLocale FunctionCreate a number from the scripting engine of the local system to indicate the current locale ID value of scripting language in use.5last updated 19 Sep 2017GetObject FunctionCreate a reference to an automation object from a file specified by pathname argument and/or a class of the object specified by the appname and objectype argumens of the class argument.5,2last updated 19 Sep 2017GetRef FunctionCreate a reference to a procedure specified by procname argument.5last updated 19 Sep 2017Hex FunctionCreate a hexadecimal number String from a given number by converting the decimal value of the given number from base 10 to a hexadecimal number of base 16.1last updated 19 Sep 2017Hour FunctionCreate an Integer with value between 0 and 23 inclusive for representing the 24 hours of a day respectively from a given time expression by getting the hour part of the given time expression.1last updated 19 Sep 2017InputBox FunctionCreate and display a standard input dialog box with a text box and a given prompt in the dialog box according to the specified title, default, xpos, ypos, helpfile and context arguments. The dialog box will wait for the user to input text or click a button to continue.1last updated 19 Sep 2017InStr FunctionCreate a number from a given string1 by getting the position of the first occurrence of a specified string2 through searching from the specified searching position start towards the end of the given string1 according to the specified compare setting.1last updated 19 Sep 2017InStrB FunctionCreate a number from a given string string1 by getting the first byte position of the first occurrence of a specified string string2 through searching from the specified searching position byte start towards the end of the given string string1 without consider the specified compare setting.1last updated 19 Sep 2017InStrRev FunctionGet the position of the first occurrence of a specified string within another given string by searching from the specified start searching position, default is at the end of string, towards the start of the given string.2last updated 19 Sep 2017Int FunctionCreate an integer value of a given number that is less than or equal to the given number.1last updated 19 Sep 2017IsArray FunctionCreate a Boolean result value from a given varname indicating whether the given varname is or can be contained by a Variant of Array data subtype.1last updated 19 Sep 2017IsDate FunctionCreate a Boolean result value from a given expression indicating whether the given expression is or can be contained by a Variant of Date data subtype.1last updated 19 Sep 2017IsEmpty FunctionCreate a Boolean result value from a given expression indicating whether the given expression is an uninitialized individual.1last updated 19 Sep 2017IsNull FunctionCreate a Boolean result value from a given expression indicating whether the given expression contains no valid data.1last updated 19 Sep 2017IsNumeric FunctionCreate a Boolean result value from a given expression indicating whether the given expression can be evaluated as a numeric value.1last updated 19 Sep 2017IsObject FunctionCreate a Boolean result value from a given expression indicating whether the given expression references a valid Automation object.1last updated 19 Sep 2017Join FunctionCreate a string from a given one-dimensional array list of substrings by joining all elements in the array accroding to the index numebr with the specified delimiter.2last updated 20 Sep 2017LBound FunctionCreate a number from a given arrayname to represent the smallest available subscript of the given arrayname according to the specified dimension.1last updated 20 Sep 2017LCase FunctionCreate a string from a given string by converting all uppercase letters of the given string to lowercase letters.1last updated 16 Sep 2017Left FunctionCreate a substring of specified character length from the left side of a given string.1last updated 20 Sep 2017LeftB FunctionCreate a substring of specified Byte length from the left side of a given string.1last updated 20 Sep 2017Len FunctionCreate a number from a given string or a specified variable by counting the number of characters in the given string or the specified variable.1last updated 20 Sep 2017LenB FunctionCreate a number from a given string or a specified variable by counting the number of bytes in the given string or the specified variable.1last updated 20 Sep 2017LoadPicture FunctionCreate a reference to a picture object from the a file specified by picturename argument.2last updated 20 Sep 2017Log FunctionConverts a given number to the natural logarithm of the given number to base e.1last updated 20 Sep 2017LTrim FunctionCreate a left trimmed string from a given string expression by removing all leading spaces on the left side of a string.1last updated 16 Sep 2017Mid FunctionCreate a substring of specified character length from the specified position start of a given string toward the end of the string.1last updated 20 Sep 2017MidB FunctionCreate a substring of specified byte length from the specified byte position start of a given string toward the end of the string.1last updated 20 Sep 2017Minute FunctionCreate an Integer with value between 0 and 59 inclusive for representing the 60 minutes of an hour respectively from a given time expression by getting the minute part of the given time expression.1last updated 20 Sep 2017Month FunctionCreate an Integer with value between 1 and 12 inclusive for representing the 12 months of a year respectively from a given date expression by getting the month part of the given date expression.1last updated 20 Sep 2017MonthName FunctionCreate a String from a given month expression by taking the given month expression as the numeric designation of the month between 1 and 12 inclusive, and with value representing the corresponding month of a year according to the specified abbreviate setting.2last updated 20 Sep 2017MsgBox FunctionCreate and display a standard message dialog box with a given prompt in the dialog box according to the specified buttons, title, helpfile and context arguments. The dialog box will wait for the user to click a button to continue.1last updated 20 Sep 2017Now FunctionCreate a date from the current date of a local computer system with format according to the date setting of the local computer system.1last updated 20 Sep 2017Oct FunctionCreate a octal number String from a given number by converting the decimal value of the given number from base 10 to a octal number of base 8.1last updated 20 Sep 2017Replace FunctionCreate a string from a substring specified by start of a given expression after replacing a specified find string with a given replacewith string according to the specified count and compare.2last updated 20 Sep 2017RGB FunctionCreate a whole number from the given red, green, and blue argument according to the RGB color converting rule.2last updated 21 Sep 2017Right FunctionCreate a substring of specified character length from the right side of a given string.1last updated 21 Sep 2017RightB FunctionCreate a substring of specified Byte length from the right side of a given string.1last updated 21 Sep 2017Rnd FunctionGet a random number according to a specified number setting.1last updated 21 Sep 2017Round FunctionCreate a numeric value of a given numeric expression according to the number of decimal places specified by numdecimalplace using the round to nearest method and following the round half to even rule that is to return the possible numeric value closest to the value of the numeric expression with the appropriate number of decimal, and following the closest to the round halt to even rule when the numeric expression is exactly halfway between two possible rounded values.2last updated 21 Sep 2017RTrim FunctionCreate a right trimmed string from a given string expression by removing all trailing spaces on the right side of a string.1last updated 16 Sep 2017ScriptEngine FunctionCreate a String from the scripting engine of the local system to indicate the scripting language in use.2last updated 21 Sep 2017ScriptEngineBuildVersion FunctionCreate a number from the scripting engine of the local system to indicate the build version number of scripting language in use.2last updated 21 Sep 2017ScriptEngineMajorVersion FunctionCreate a number from the scripting engine of the local system to indicate the major version number of scripting language in use.2last updated 21 Sep 2017ScriptEngineMinorVersion FunctionCreate a number from the scripting engine of the local system to indicate the minor version number of scripting language in use.2last updated 21 Sep 2017Second FunctionCreate an Integer with value between 0 and 59 inclusive for representing the 60 seconds of a minute respectively from a given time expression by getting the second part of the given time expression.1last updated 21 Sep 2017SetLocale FunctionCreate a number from the scripting engine of the local system to indicate the current locale ID value of scripting language in use. And then set the global locale ID value of scripting language according to the specified lcid for the scripting engine of the local system.5last updated 21 Sep 2017Sgn FunctionCreate an integer to indicate the sign of a given number.1last updated 21 Sep 2017Sin FunctionConverts a given number to the sine of the given number by taking the given number as an angle in radian.1last updated 21 Sep 2017Space FunctionCreate a string of a specified number of repeating spaces.1last updated 21 Sep 2017Split FunctionCreate a zero-based one-dimensional array from a given expression by breaking the string of the given expression from the beginning to the end into a list of ordered substring elements which is then arranged as members of the array.2last updated 16 Sep 2017Sqr FunctionCreate the square root of a given number.1last updated 21 Sep 2017StrComp FunctionCreate a value to indicate the result of comparison between given string1 and string2 according to the specified compare setting.1last updated 21 Sep 2017String FunctionCreate a string of a specified number of the repeating character obtained from the first character of a given string expression specified by character argument.1last updated 21 Sep 2017StrReverse FunctionCreate a string from a given string1 by reversing the character order of the given string1 from the end to the beginning.2last updated 21 Sep 2017Tan FunctionConverts a given number to the tangent of the given number by taking the given number as an angle in radian.1last updated 21 Sep 2017Time FunctionCreate a time part of the date from the current date of a local computer system with format according to the time setting of the local computer system.1last updated 21 Sep 2017Timer FunctionCreate a numeric value from time part of current local system time by counting the elapsed seconds since 12:00 AM, midnight, or 00:00.5last updated 21 Sep 2017TimeSerial FunctionCreate a date from given numeric expressions of hour, minute, and second.1last updated 21 Sep 2017TimeValue FunctionCreate the time part of a date from a given date string.1last updated 21 Sep 2017Trim FunctionCreate a trimmed string from a given string expression by removing both leading and trailing spaces on both sides of a string.1last updated 16 Sep 2017TypeName FunctionCreate a String from a given varname to indicate the Variant subtype name of a variable.2last updated 21 Sep 2017UBound FunctionCreate a number from a given arrayname to represent the largest available subscript of the given arrayname according to the specified dimension.1last updated 21 Sep 2017UCase FunctionCreate a string from a given string by converting all lowercase letters of the given string to uppercase letters.1last updated 16 Sep 2017Unescape FunctionDecodes a string encoded with the Escape function.5last updated 21 Sep 2017VarType FunctionCreate an Integer from a given varname to indicate the subtype of a variable.1last updated 21 Sep 2017Weekday FunctionCreate an Integer with value between 1 and 7 inclusive for representing the 7 days of a week respectively from a given date expression by getting the default weekday part of the given date expression according to firstdayofweek setting.1last updated 21 Sep 2017WeekdayName FunctionCreate a String from a given weekday expression by taking the given weekday expression as the numeric designation of the week between 1 and 7 inclusive based on the specified firstdayofweek setting, and with value representing the corresponding weekday of a week according to the specified abbreviate setting.2last updated 21 Sep 2017Year FunctionCreate a Integer from a given date expression by getting the year part of the given date expression.1last updated 21 Sep 2017

Sources

• https://msdn.microsoft.com/en-us/library/4y5y7bh5.aspx
• https://msdn.microsoft.com/en-us/library/aa227640(v=vs.60).aspx