The Calculation Manager Function Selector supports these VB functions.
Note: | You can also use other VB functions in the script component, even though they are not available in the UI for selection. |
Array Functions
Function | Description |
|---|---|
Array | Returns a variant containing an array |
Filter | Returns a zero-based array that contains a subset of a string array based on a filter criteria |
Join | Returns a string that consists of a number of substrings in an array |
LBound | Returns the smallest subscript for the indicated dimension of an array |
Split | Returns a zero-based, one-dimensional array that contains a specified number of substrings |
UBound | Returns the largest subscript for the indicated dimension of an array |
Date Time Functions
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 specified date |
DateSerial | Returns the date for a specified year, month, and day |
Day | Returns a number that represents the day of the month (between 1 and 31, inclusive) |
Month | Returns a number that represents the month of the year (between 1 and 12, inclusive) |
MonthName | Returns the name of a specified month |
Mathematical
Function | Description |
|---|---|
Abs | Returns the absolute value of a specified number |
Fix | Returns the integer part of a specified number |
Int | Returns the integer part of a specified number |
String
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 a 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 |
Mid | Returns a specified number of characters from a string |
Right | Returns a specified number of characters from the right side of a string |
StrComp | Compares two strings and returns a value that represents the result of the comparison |
Trim | Removes spaces on both the left and right side of a string |
UCase | Converts a specified string to uppercase |