abs(number)
Returns the absolute value.
array(arglist)
Create an array.
asc(string)
Returns the ansi code of the first character of the string.
atn(number)
Returns the inverse sine value.
cbool (expression)
Convert to 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)
Convert to double data type variable.
chr(charcode)
Convert ansi code to the corresponding keyboard characters.
cint (expression)
Convert to integer data type variable.
clng (expression)
Convert to long data type variable.
createobject(servername.typename)
Create an automatic object.
csng (expression)
Convert to single data type variable.
cstr (expression)
Convert to string data type variable.
date
Return time according to the system used.
dateadd(interval,number,date)
Adds the specified time interval to the date object. where parameter interval accepts the values shown in the following table.
Set value
describe
yyy
Year
q
Quarterly
m
month
y
What day of the year
d
sky
w
What day of the week
ww
What week of the year
h
Hour
m
minute
Seconds
datediff(interval,date1,date2])
Return the interval between two dates. For the values of firstdayofweek and firstweekofyear, please refer to the "Date and Time Constant" section below. The interval parameter accepts the values shown in the table below.
Set value
describe
yyy
Year
q
Quarterly
m
month
y
What day of the year
d
sky
w
What day of the week
ww
What week of the year
h
Hour
m
minute
Seconds
datepart(interval , date])
Returns the specified part of the date object. For the values of firstdayofweek and firstweekofyear, please refer to the "Date and Time Constant" section below. The interval parameter accepts the values shown in the table below.
Set value
describe
yyy
Year
q
Quarterly
m
month
y
What day of the year
d
sky
w
What day of the week
ww
What week of the year
h
Hour
m
minute
Seconds
dateserial(year, month, day)
Convert to date data subtype variant value.
datevalue(date)
Convert to date data subtype variant value.
day(date)
Return the number of the day in one month according to the parameter date.
exp(number)
Returns the value to the power of e.
filter(inputstrings,value])
Create a new array based on the filter criteria. For the value of compare, see the "Compare Constant" section later.
fix(number)
Convert to an integer (for negative numbers, only enter and don't leave).
formatcurrency(expression]]])
Formatted into currency form. For the values of includedigit, useparensfornegativenumbers and groupdigit, please refer to the "Three-state Constant" section below.
formatdatetime(date)
Format the date and time. For the value of namedformat, please refer to the "Date Format Constant" section below.
formatnumber(expression]]])
Format the numbers. For the values of includedigit, useparensfornegativenumbers and groupdigit, please refer to the "Three-state Constant" section below.