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
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.