Date and Time Functions

CDATE	Returns the expression converted to a date data type (Date).
CVDATE	Returns the expression converted to a variant data type (Variant).
DATE - Function	Returns the current system date (Date).
DATE - Statement	Defines the current system date.
DATEADD	Returns the date to which a specified time interval has been added (Date).
DATEDIFF	Returns the number of time intervals between two specified dates (Long).
DATEPART	Returns the specified part of a given date (Integer).
DATESERIAL	Returns the date given a year, month and day (Date).
DATEVALUE	Returns the date given a string representation of a date (Date).
DAY	Returns the day from a given date (Integer).
FORMAT	Returns the text string of a number or date in a particular format (String).
FORMATDATETIME	Returns the expression formatted as a date or time (String).
HOUR	Returns the hour from a given time (Integer).
INT	Returns the integer portion of a number (Double).
ISDATE	Returns the value indicating if an expression is a date (Boolean).
MINUTE	Returns the minute from a given time (Integer).
MONTH	Returns the month from a given date (Integer).
MONTHNAME	Returns the month as a string (String).
NOW	Returns the current system date and time (Date).
SECOND	Returns the second from a given time (Integer).
TIME - Function	Returns the current system time (Date).
TIME - Statement	Defines the current system time.
TIMER	Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL	Returns the time for a specific hour, minute and second (Date).
TIMEVALUE	Returns the time given a string representation of a time (Date).
WEEKDAY	Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME	Returns the day of the week as a string (String).
YEAR	Returns the year from a date (Integer).

CDATE Returns the expression converted to a date data type (Date).
CVDATE Returns the expression converted to a variant data type (Variant).
DATE - Function Returns the current system date (Date).
DATE - Statement Defines the current system date.
DATEADD Returns the date to which a specified time interval has been added (Date).
DATEDIFF Returns the number of time intervals between two specified dates (Long).
DATEPART Returns the specified part of a given date (Integer).
DATESERIAL Returns the date given a year, month and day (Date).
DATEVALUE Returns the date given a string representation of a date (Date).
DAY Returns the day from a given date (Integer).
FORMAT Returns the text string of a number or date in a particular format (String).
FORMATDATETIME Returns the expression formatted as a date or time (String).
HOUR Returns the hour from a given time (Integer).
INT Returns the integer portion of a number (Double).
ISDATE Returns the value indicating if an expression is a date (Boolean).
MINUTE Returns the minute from a given time (Integer).
MONTH Returns the month from a given date (Integer).
MONTHNAME Returns the month as a string (String).
NOW Returns the current system date and time (Date).
SECOND Returns the second from a given time (Integer).
TIME - Function Returns the current system time (Date).
TIME - Statement Defines the current system time.
TIMER Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL Returns the time for a specific hour, minute and second (Date).
TIMEVALUE Returns the time given a string representation of a time (Date).
WEEKDAY Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME Returns the day of the week as a string (String).
YEAR Returns the year from a date (Integer).