Dates & Times Functions

CDATEReturns the expression converted to a date data type (Date).
CVDATEReturns the expression converted to a date variant-subtype (Variant).
DATE - FunctionReturns the current system date (Date).
DATE - StatementDefines the current system date.
DATEADDReturns the date with a specified time interval added (Date).
DATEDIFFReturns the number of a given time interval between two specified dates (Long).
DATEPARTReturns the specified part of a given date (Integer).
DATESERIALReturns the date given a year, month and day (Date).
DATEVALUEReturns the date given a string representation of a date (Date).
DAYReturns the day from a given date (Integer).
FORMATDATETIMEReturns the expression formatted as a date or time (String).
HOURReturns the hour from a given time (Integer).
ISDATEReturns the value True or False depending if the expression is a date (Boolean).
MINUTEReturns the minutes from a given time (Integer).
MONTHReturns the month from a given date (Integer).
MONTHNAMEReturns the month as a string (String).
NOWReturns the current system date and time (Date).
SECONDReturns the seconds from a given time (Integer).
TIME - FunctionReturns the current system time (Date).
TIME - StatementDefines the current system time.
TIMERReturns the number of seconds elapsed since midnight (Single).
TIMESERIALReturns the time for a specific hour, minute and second (Date).
TIMEVALUEReturns the time given a string representation of a time (Date).
WEEKDAYReturns the number representing the day of the week for a given date (Integer).
WEEKDAYNAMEReturns the day of the week as a string (String).
YEARReturns the year from a date (Integer).
CDATE
Returns the expression converted to a date data type (Date).
CVDATE
Returns the expression converted to a date variant-subtype (Variant).
DATE - Function
Returns the current system date (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 (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).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top