|
Date()
Returns the current system date.
Syntax: Date
DateAdd()
Returns a date to which a specified time interval has been
added.
Syntax: DateAdd( interval, number,
date)
Interval is a string expression that is the
interval you want to add. number is a numeric expression that is the
number of intervals you want to add. The numeric expression can either
be positive for dates in the future or negative for dates in
the past. date is a variant or literal representing the date to which
interval is added.
DateDiff()
Returns the number of intervals between two dates.
Syntax: DateDiff (interval, date1,
date2 (,firstdayofweek[, firstweekofyear]])
Interval is a string expression that is the
interval you want to use to calculate the
differences between date1 and date2. date1, date2 are date expressions
you want to use in the calculation.firstdayofweek (Optional) is a
constant that specifies the day of the week. If not
specified, Sunday is assumed. firstweekofyear (Optional) is a
constant that specifies the first week of the year. If not
specified, the first week is assumed to be that week in which January
1 occurs.
DatePart()
Returns the specified part of a given date.
syntax: DatePart( interval, date [
, firstdayofweek [ , firstweekofyear]])
Interval is a string expression that is the
interval of time you want to return. date is the date expression
you want to evaluate. firstdayofweek (Optional) is a constant that
specifies the day of the week. If not specified, Sunday is
assumed. firstweekofyear (Optional) is a constant that specifies
the first week of the year. If not specified, the first week is
assumed to be the week in which January 1 occurs.
DateSerial()
Returns a Variant of subtype Date for a specified year,
month, and day.
Syntax: DateSerial(year, month, day)
year is a number between 100 and 9999,
inclusive, or a numeric expression. month is any numeric expression. day
is any numeric expression.
DateValue()
Returns a Variant of subtype Date.
Syntax: DateValue (date)
Date is a string expression representing a date
from January 1, 100 through December 31, 9999. However, date can also be
any expression that can represent a date, a time, or both a date and
time, in that range.
Day()
Returns a whole number between 1 and 31, inclusive,
representing the day of the month.
Syntax: Day(date)
Date is any expression that can represent a date. If
date contains Null, Null is returned.
Exp()
Returns e (the base of natural logarithms) raised to a
power.
Syntax: Exp(number)
Number is any valid numeric expression.
Filter()
Returns a zero-based array containing subset of a string array based on
a specified filter criteria.
Syntax: Filter(InputStrings, Value [ ,
Include [ , Compare]])
InputStrings is a one-dimensional array of
strings to be searched.Value is the string to search for. Include
(Optional) is a boolean value indicating whether to return substrings
that include or exclude Value. If Include is True, Filter returns
the subset of the array that contains Value as a substring. If Include
is False, Filter returns the subset of the array that does not
contain Value as a substring. Compare (Optional) is a numeric value
indicating the kind of string comparison to use.
Fix()
Returns the integer portion of a number.
Syntax: Fix(number)
Number is any valid numeric expression. If
number contains Null, Null is returned.
|
