Ccur (String) is converted to a currency class value
Cdate (String) is converted to a value of a day-ago type
Cdbl (String) is converted to a double value
Cint (String) is converted to an integer value
Clng (String) to a value of a long integer
CSng (String) is converted to a single-precision value
Cstr (Var) conversion to a string value
Str (Var) numeric conversion to string
Val (String) string converted to numeric
****** ******
****** ******
Abs (NMB) returns the absolute value of the number of children
Atn (NMB) returns a number of the tangent
Cos (NMB) returns the afterglow value of an angle
EXP (NMB) returns the secondary value of the natural exponent
Int (NMB) returns the Shaping (rounding) part of a number
Fix (NMB) returns the number of plastic (shed) parts
formatpercent (expression) return percent
Hex (NMB) returns the number of 16 in the data
log (NMB) returns the natural logarithm
Oct (NMB) returns the number of 8-in-number
Rnd Returns a random number greater than "0" and less than "1"
Sgn (NMB) determines the positive and negative number of a number
Sin (NMB) returns the positive-hyun value of the angle
SQR (NMB) returns the two square root of the number
Tan (NMB) returns the tangent of a number
ASC (String) returns an ASCII string
Chr (charcode) returns characters based on character code
Instr (STRING,SEARCHSTR) returns the position of the first character of the searched string, string, and searchstr is the searched string
InStrRev (STRING,SEARCHSTR) ditto, just start the search from the right
Lcase (Var) changes the string to lowercase
Left (STRING,NMB) returns the NMB string from a string
Len (String) returns the length of the string
Ltrim (String) truncates the space to the left of the string
Filter (Inputstrings,value) returns a string array of words, Inputstrings is a string group, and value is the character found in the array
Rtrim (String) truncates the space to the right of the string
Trim (String) to truncate the space before and after the string
Mid (String,start,len) returns the Len character from the start position in string
replace (STRING,FIND,WITHSTR) replaces the find string with Withstr in string strings
Right (STRING,NMB) returns a NMB string from the right starting from a string
Space (NMB) returns a string of specified spaces
StrComp (string1,string2) compares two strings
Ucase (string) into uppercase
****** ******
****** ******
Date () returns the current system day
DATEADD (interval,nmb,date) returns the specified time interval with a base time, interval is the interval type, yyyy-year, M-month, D-Day, H-hour, N-Min.
DateDiff (INTERVAL,NMB1,NMB2) returned two intervals, interval the meaning of ditto
Datevalue (date) plays the dates part in date
Day (date) returns the number of days
FormatDateTime (date) Returns an expression formatted as a date
Hour (time) returns the number of hours
Minute (time) returns the number of minutes
Month (date) Returns the month of the date
Now () returns the date and time of the system
Second (time) returns the number of seconds in the
time () returns the system's current
Weekday (date) returns the day of the week
WeekdayName (date) returns the Chinese name of the day of the week
year (date) return
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 an expression contains a numeric value
IsObject (Var) determines whether a variable is an object
TypeName (VAR) returns the data type of a variable
****** ******
****** ******
Array (list) returns an array
CreateObject (Class) creates an object
GetObject (pathfilename) Gets the file object
Inputbox (Prompt) provides a dialog box to enter data
LBound (ARRAYP returns the smallest index of an 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 an array
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.