| Function | Description | |
|---|
| Abs Function | Create an unsigned magnitude, or the absolute value of a given number.
| last updated 9/16/2017 |
| Array Function | Create 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.
| last updated 9/16/2017 |
| Asc Function | Create 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.
| last updated 9/16/2017 |
| AscB Function | Create a Byte from the first byte of the character code of first character of a given string.
| last updated 9/16/2017 |
| AscW Function | Create a decimal Unicode (wide) character code from the character code of first character of a given string.
| last updated 9/16/2017 |
| Atn Function | Converts a given number to an angle in radian by taking the inverse trigonometric function of tangent function of the given number.
| last updated 9/16/2017 |
| CBool Function | Create a Boolean result value of a given expression.
| last updated 9/16/2017 |
| CByte Function | Create a Byte data subtype value from a given expression.
| last updated 9/16/2017 |
| CCur Function | Create a Currency data subtype value from a given expression.
| last updated 9/16/2017 |
| CDate Function | Create a Date data subtype value from a given expression.
| last updated 9/16/2017 |
| CDbl Function | Create a Double data subtype value from a given expression.
| last updated 9/16/2017 |
| Chr Function | Create an ANSI character string from a given charcode by evaluating the given charcode as the ANSI character code of the associated character.
| last updated 9/16/2017 |
| ChrB Function | Create a character string from a given charcode by evaluating the given charcode as the Byte code of the associated character.
| last updated 9/16/2017 |
| ChrW Function | Create 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.
| last updated 9/16/2017 |
| CInt Function | Create an Integer data subtype value from a given expression.
| last updated 9/17/2017 |
| CLng Function | Create a Long data subtype value from a given expression.
| last updated 9/17/2017 |
| Cos Function | Converts a given number to the cosine of the given number by taking the given number as an angle in radian.
| last updated 9/17/2017 |
| CreateObject Function | Create a reference to an automation object specified by servername and typename arguments of the object on a location according to the location argument.
| last updated 9/17/2017 |
| CSng Function | Create a Single data subtype value from a given expression.
| last updated 9/17/2017 |
| CStr Function | Create a String data subtype value from a given expression.
| last updated 9/17/2017 |
| Date Function | Create 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.
| last updated 9/17/2017 |
| DateAdd Function | Create a date from a given date by adding the specified number of interval to the given date.
| last updated 9/17/2017 |
| DateDiff Function | Create a number from two given dates by counting the specified interval from date1 to date2 according to firstdayofweek and firstweekofyear setting.
| last updated 9/18/2017 |
| DatePart Function | Create a Integer from a given valid Date expression according the the specified interval argument, and firstdayofweek and firstweekofyear settings.
| last updated 9/18/2017 |
| DateSerial Function | Create a date from given numeric expressions of year, month, and day.
| last updated 9/18/2017 |
| DateValue Function | Create a date part of date from a given acceptable date string.
| last updated 9/18/2017 |
| Day Function | Create 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.
| last updated 9/18/2017 |
| Escape Function | Create 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.
| last updated 9/18/2017 |
| Eval Function | Create a evaluation result from a given expression.
| last updated 9/18/2017 |
| Exp Function | Converts a given number to the base of natural logarithms, e, raised to a power of the given number.
| last updated 9/18/2017 |
| Filter Function | Create a zero-based array by filtering a given InputStrings according to the specified search Value, and the specified Include and Compare settings.
| last updated 9/18/2017 |
| Fix Function | Create 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.
| last updated 9/19/2017 |
| FormatCurrency Function | Create 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.
| last updated 9/18/2017 |
| FormatDateTime Function | Create 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.
| last updated 9/18/2017 |
| FormatNumber Function | Create 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.
| last updated 9/18/2017 |
| FormatPercent Function | Create 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.
| last updated 9/19/2017 |
| GetLocale Function | Create a number from the scripting engine of the local system to indicate the current locale ID value of scripting language in use.
| last updated 9/19/2017 |
| GetObject Function | Create 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.
| last updated 9/19/2017 |
| GetRef Function | Create a reference to a procedure specified by procname argument.
| last updated 9/19/2017 |
| Hex Function | Create 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.
| last updated 9/19/2017 |
| Hour Function | Create 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.
| last updated 9/19/2017 |
| InputBox Function | Create 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.
| last updated 9/19/2017 |
| InStr Function | Create 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.
| last updated 9/19/2017 |
| InStrB Function | Create 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.
| last updated 9/19/2017 |
| InStrRev Function | Get 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.
| last updated 9/19/2017 |
| Int Function | Create an integer value of a given number that is less than or equal to the given number.
| last updated 9/19/2017 |
| IsArray Function | Create 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.
| last updated 9/19/2017 |
| IsDate Function | Create 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.
| last updated 9/19/2017 |
| IsEmpty Function | Create a Boolean result value from a given expression indicating whether the given expression is an uninitialized individual.
| last updated 9/19/2017 |
| IsNull Function | Create a Boolean result value from a given expression indicating whether the given expression contains no valid data.
| last updated 9/19/2017 |
| IsNumeric Function | Create a Boolean result value from a given expression indicating whether the given expression can be evaluated as a numeric value.
| last updated 9/19/2017 |
| IsObject Function | Create a Boolean result value from a given expression indicating whether the given expression references a valid Automation object.
| last updated 9/19/2017 |
| Join Function | Create 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.
| last updated 9/20/2017 |
| LBound Function | Create a number from a given arrayname to represent the smallest available subscript of the given arrayname according to the specified dimension.
| last updated 9/20/2017 |
| LCase Function | Create a string from a given string by converting all uppercase letters of the given string to lowercase letters.
| last updated 9/16/2017 |
| Left Function | Create a substring of specified character length from the left side of a given string.
| last updated 9/20/2017 |
| LeftB Function | Create a substring of specified Byte length from the left side of a given string.
| last updated 9/20/2017 |
| Len Function | Create a number from a given string or a specified variable by counting the number of characters in the given string or the specified variable.
| last updated 9/20/2017 |
| LenB Function | Create a number from a given string or a specified variable by counting the number of bytes in the given string or the specified variable.
| last updated 9/20/2017 |
| LoadPicture Function | Create a reference to a picture object from the a file specified by picturename argument.
| last updated 9/20/2017 |
| Log Function | Converts a given number to the natural logarithm of the given number to base e.
| last updated 9/20/2017 |
| LTrim Function | Create a left trimmed string from a given string expression by removing all leading spaces on the left side of a string.
| last updated 9/16/2017 |
| Mid Function | Create a substring of specified character length from the specified position start of a given string toward the end of the string.
| last updated 9/20/2017 |
| MidB Function | Create a substring of specified byte length from the specified byte position start of a given string toward the end of the string.
| last updated 9/20/2017 |
| Minute Function | Create 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.
| last updated 9/20/2017 |
| Month Function | Create 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.
| last updated 9/20/2017 |
| MonthName Function | Create 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.
| last updated 9/20/2017 |
| MsgBox Function | Create 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.
| last updated 9/20/2017 |
| Now Function | Create a date from the current date of a local computer system with format according to the date setting of the local computer system.
| last updated 9/20/2017 |
| Oct Function | Create 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.
| last updated 9/20/2017 |
| Replace Function | Create 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.
| last updated 9/20/2017 |
| RGB Function | Create a whole number from the given red, green, and blue argument according to the RGB color converting rule.
| last updated 9/21/2017 |
| Right Function | Create a substring of specified character length from the right side of a given string.
| last updated 9/21/2017 |
| RightB Function | Create a substring of specified Byte length from the right side of a given string.
| last updated 9/21/2017 |
| Rnd Function | Get a random number according to a specified number setting.
| last updated 9/21/2017 |
| Round Function | Create 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.
| last updated 9/21/2017 |
| RTrim Function | Create a right trimmed string from a given string expression by removing all trailing spaces on the right side of a string.
| last updated 9/16/2017 |
| ScriptEngine Function | Create a String from the scripting engine of the local system to indicate the scripting language in use.
| last updated 9/21/2017 |
| ScriptEngineBuildVersion Function | Create a number from the scripting engine of the local system to indicate the build version number of scripting language in use.
| last updated 9/21/2017 |
| ScriptEngineMajorVersion Function | Create a number from the scripting engine of the local system to indicate the major version number of scripting language in use.
| last updated 9/21/2017 |
| ScriptEngineMinorVersion Function | Create a number from the scripting engine of the local system to indicate the minor version number of scripting language in use.
| last updated 9/21/2017 |
| Second Function | Create 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.
| last updated 9/21/2017 |
| SetLocale Function | Create 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.
| last updated 9/21/2017 |
| Sgn Function | Create an integer to indicate the sign of a given number.
| last updated 9/21/2017 |
| Sin Function | Converts a given number to the sine of the given number by taking the given number as an angle in radian.
| last updated 9/21/2017 |
| Space Function | Create a string of a specified number of repeating spaces.
| last updated 9/21/2017 |
| Split Function | Create 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.
| last updated 9/16/2017 |
| Sqr Function | Create the square root of a given number.
| last updated 9/21/2017 |
| StrComp Function | Create a value to indicate the result of comparison between given string1 and string2 according to the specified compare setting.
| last updated 9/21/2017 |
| String Function | Create a string of a specified number of the repeating character obtained from the first character of a given string expression specified by character argument.
| last updated 9/21/2017 |
| StrReverse Function | Create a string from a given string1 by reversing the character order of the given string1 from the end to the beginning.
| last updated 9/21/2017 |
| Tan Function | Converts a given number to the tangent of the given number by taking the given number as an angle in radian.
| last updated 9/21/2017 |
| Time Function | Create 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.
| last updated 9/21/2017 |
| Timer Function | Create a numeric value from time part of current local system time by counting the elapsed seconds since 12:00 AM, midnight, or 00:00.
| last updated 9/21/2017 |
| TimeSerial Function | Create a date from given numeric expressions of hour, minute, and second.
| last updated 9/21/2017 |
| TimeValue Function | Create the time part of a date from a given date string.
| last updated 9/21/2017 |
| Trim Function | Create a trimmed string from a given string expression by removing both leading and trailing spaces on both sides of a string.
| last updated 9/16/2017 |
| TypeName Function | Create a String from a given varname to indicate the Variant subtype name of a variable.
| last updated 9/21/2017 |
| UBound Function | Create a number from a given arrayname to represent the largest available subscript of the given arrayname according to the specified dimension.
| last updated 9/21/2017 |
| UCase Function | Create a string from a given string by converting all lowercase letters of the given string to uppercase letters.
| last updated 9/16/2017 |
| Unescape Function | Decodes a string encoded with the Escape function.
| last updated 9/21/2017 |
| VarType Function | Create an Integer from a given varname to indicate the subtype of a variable.
| last updated 9/21/2017 |
| Weekday Function | Create 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.
| last updated 9/21/2017 |
| WeekdayName Function | Create 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.
| last updated 9/21/2017 |
| Year Function | Create a Integer from a given date expression by getting the year part of the given date expression.
| last updated 9/21/2017 |
Sideway
BICK BLOG from Sideway
