function Abs (number)
Returns the absolute value.
Array (arglist)
Creates an array.
ASC (String)
Returns the ANSI code for the first character of a string.
ATN (number)
Returns the inverse chord value.
CBool (expression)
Converts to a Boolean data type variable.
CByte (expression)
Convert to byte data type variable.
CCur (expression)
Convert to Currency data type variable.
CDate (expression)
Convert to date data type variable.
CDBL (expression)
Converts to a double data type variable.
CHR (CharCode)
Converts the ANSI code to the corresponding keyboard character.
CINT (expression)
Converts to an integer data type variable.
CLng (expression)
Converts to a Long data type variable.
CreateObject (Servername.typename)
Creates an automatic object.
CSng (expression)
Convert to single data type variable.
CSTR (expression)
Converts to a string data type variable.
Date
Returns the time according to the system used.
DATEADD (Interval,number,date)
Adds a specified time interval to the Date object. Where the parameter interval accepts the values shown in the following table.
Set Value
Describe
yyyy
Years
Q
Quarter
M
Month
Y
The first day of the year
D
Days
W
Day of the Week
Ww
The first few weeks of the year
H
Hours
M
Minutes
S
Seconds
DateDiff (Interval,date1,date2[,firstdayofweek[,firstweekofyear]])
Returns the interval between two dates, the values for FirstDayOfWeek and FirstWeekOfYear refer to the "Date and time Constants" section below. The interval parameter accepts the values shown in the following table.
Set Value
Describe
yyyy
Years
Q
Quarter
M
Month
Y
The first day of the year
D
Days
W
Day of the Week
Ww
The first few weeks of the year
H
Hours
M
Minutes
S
Seconds
DatePart (interval, date[,firstdayofweek[,firstweekofyear])
Returns the specified portion of the Date object. For FirstDayOfWeek and FirstWeekOfYear values, refer to the "Date and time Constants" section below. The interval parameter accepts the values shown in the following table.
Set Value
Describe
yyyy
Years
Q
Quarter
M
Month
Y
The first day of the year
D
Days
W
Day of the Week
Ww
The first few weeks of the year
H
Hours
M
Minutes
S
Seconds
DateSerial (Year,month,day)
Converts to a date data subtype variant value.
DateValue (date)
Converts to a date data subtype variant value.
Day (date)
Returns the numbered of the day in one months, based on the parameter date.
EXP (number)
Returns the value of the number-second side of E.
Filter (Inputstrings,value[,include[,compare]])
Creates a new array based on the filter criteria. For a compare value, see the "Comparison Constants" section later.
Fix (number)
Converts to an integer (in the case of negative numbers, only in the shed).
FormatCurrency (Expression[,numdigitsafterdecimal [, includeleadingdigit[,useparensfornegativenumbers [, GroupDigit ]]]])
Format into currency form. For includeleadingdigit,useparensfornegativenumbers and Groupdigit values, refer to the "three-state Constants" section later.
FormatDateTime (Date[,namedformat])
Format the output for the date and time. For NamedFormat values, see the "Date Format constants" section later.
FormatNumber (Expression[,numdigitsafterdecimal [, Includeleadingdigit[,useparensfornegativenumbers [, GroupDigit]] ]])
Formats the numbers. For includeleadingdigit,useparensfornegativenumbers and Groupdigit values, refer to the "three-state Constants" section later.
FormatPercent (Expression[,numdigitsafterdecimal [, Includeleadingdigit[,useparensfornegativenumbers [, GroupDigit] ]]])
The percentages are formatted. For includeleadingdigit,useparensfornegativenumbers and Groupdigit values, refer to the "three-state Constants" section later.
GetObject ([Pathname][,class])
Returns the specified dynamic object from the specified file.
Hex (number)
Returns the hexadecimal value of the number.
Hour (Time)
Returns an hour based on the value of the parameter time.
InputBox (Prompt[,title][,default][,xpos][,ypos][,helpfile,context])
Displays a temporary input box and returns the user's input.
INSTR ([Start,]string1,string2[,compare])
Returns the position of the first occurrence of the string string2 in the string string1. Refer to the "Comparison constants" section later on for compare values.
InStrRev (string1,string2 [start [, compare]])
Returns the position of the last occurrence of the string string2 in the string string1. Refer to the "Comparison constants" section later on for compare values.
Int (number)
Returns an integer (the negative number is not placed).
IsArray (varname)
Determines whether a variable is an array.
IsDate (expression)
Determines whether an expression expression can be converted to a date format.
IsEmpty (varname)
Determines whether the variable has been initialized.
IsNull (expression)
Determines whether an expression expression is empty.
Isnumberic (expression)
Determines whether the result of an expression expression is a number.
IsObject (expression)
Determines whether an expression expression is an automatic object.
Join (List,[,delimiter])
Concatenate all substrings in an array, and the delimiters used by the connection are set by the value of the Delimiterd.
LBound (Arrayname[,dimension])