Dates & Times Functions

CDATE	Returns the expression converted to a date data type (Date).
CVDATE	Returns the expression converted to a variant date subtype (Variant).
DATE - Function	Returns the current system date (Variant / Date).
DATE - Statement	Defines the current system date.
DATEADD	Returns the date with a specified time interval added (Date).
DATEDIFF	Returns the number of a given time interval between two specified dates (Long).
DATEPART	Returns the specified part of a given date (Variant / 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).
FORMATDATETIME	Returns the expression formatted as a date or time (String).
HOUR	Returns the hour from a given time (Integer).
ISDATE	Returns the value True or False depending if the expression is a date (Boolean).
MINUTE	Returns the minutes 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 seconds 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 date subtype (Variant).
DATE - Function Returns the current system date (Variant / Date).
DATE - Statement Defines the current system date.
DATEADD Returns the date with a specified time interval added (Date).
DATEDIFF Returns the number of a given time interval between two specified dates (Long).
DATEPART Returns the specified part of a given date (Variant / 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).
FORMATDATETIME Returns the expression formatted as a date or time (String).
HOUR Returns the hour from a given time (Integer).
ISDATE Returns the value True or False depending if the expression is a date (Boolean).
MINUTE Returns the minutes 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 seconds 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).