function name function function
Cbool(string) Convert to Boolean value
Cbyte(string) Convert to byte type value
Ccur(string) Convert to currency value
Cdate(string) Convert to day-ahead type value
Cdbl(string) Convert to double value
Cint(string) Convert to integer value
Clng(string) Convert to long integer value
Csng(string) Convert to single precision value
Cstr(var) Convert to string value
Str(var) Convert numerical value to string
Val(string) Convert string to numerical value
****** ******
****** ******
Abs(nmb) returns the absolute value of the number
Atn(nmb) returns the arctangent of a number
Cos(nmb) returns the codazzle value of an angle
Exp(nmb) returns the natural exponent raised to the power
Int(nmb) returns the integer (carry) part of the number
Fix(nmb) returns the integer (truncated) part of the number
Formatpercent(expression) returns percentage
Hex(nmb) returns the hexadecimal number of the data
Log(nmb) returns the natural logarithm
Oct(nmb) returns the octal number of the number
Rnd returns a random number greater than 0 and less than 1
Sgn(nmb) determines the sign of a number
Sin(nmb) returns the positive positive value of the angle
Sqr(nmb) returns the square root of a number
Tan(nmb) returns the tangent of a number
Asc(string) returns ASCII string
Chr(charcode) returns the character based on the character code
Instr(string,searchstr) returns the first character position of the searched string, string is the string, searchstr is the searched string
InstrRev(string,searchstr) Same as above, just start searching from the right
Lcase(var) changes the string to lowercase
Left(string,nmb) Returns nmb strings starting from the left from string
Len(string) returns the length of the string
Ltrim(string) truncate the spaces on the left side of the string
Filter(inputstrings,value) returns the character set of the string array. Inputstrings is the string group and value is the character found in the array.
Rtrim(string) trims the spaces on the right side of the string
Trim(string) trims the spaces before and after the string
Mid(string,start,len) returns len characters starting from the start position in string
Replace(string,find,withstr) In the string string, replace the find string with withstr
Right(string,nmb) returns nmb strings starting from the right from string
Space(nmb) returns a string with specified spaces
StrComp(string1,string2) compares two strings
Ucase(string) changes the string to uppercase
****** ******
****** ******
Date() returns the current system date
DateAdd(interval,nmb,date) uses a base time to return the date with the specified added time interval. interval is the interval type, yyyy-year, m-month, d-day, h-hour, n-minute.
DateDiff(interval,nmb1,nmb2) returns two time intervals, the meaning of interval is the same as above
Datevalue(date) plays the date part of Date
Day(date) returns the number of days
FormatDatetime(date) returns an expression formatted as a date
Hour(time) returns the hour of time
Minute(time) returns the number of minutes of time
Month(date) returns the month in the date
Now() returns the system date and time
Second(time) returns the number of seconds in time
Time() returns the current time of the system
Weekday(date) returns the day of the week
WeekdayName(date) returns the Chinese name of the day of the week
Year(date) returns the year
IsArray(var) determines whether a variable is an array
IsDate(var) determines whether a variable is a date
IsNull(var) determines whether a variable is empty
IsNumeric determines whether the expression contains a numeric value
IsObject(var) determines whether a variable is an object
TypeName(var) returns the data type of the variable
****** ******
****** ******
Array(list) returns array
CreateObject(class) creates an object
GetObject(pathfilename) gets the file object
Inputbox(prompt) provides a dialog box for entering data
LBound(arrayP returns the minimum index of the array
Msgbox(string) outputs a message box
Split(liststr) returns a one-dimensional array from a list string
Ubound(array) returns the maximum index of the array