Date and Time Functions

CDATEReturns the expression converted to a date data type (Date).
CVDATEReturns the expression converted to a variant data type (Variant).
DATE - FunctionReturns the current system date (Date).
DATE - StatementDefines the current system date.
DATEADDReturns the date to which a specified time interval has been added (Date).
DATEDIFFReturns the number of time intervals 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).
FORMATReturns the text string of a number or date in a particular format (String).
FORMATDATETIMEReturns the expression formatted as a date or time (String).
HOURReturns the hour from a given time (Integer).
INTReturns the integer portion of a number (Double).
ISDATEReturns the value indicating if an expression is a date (Boolean).
MINUTEReturns the minute 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 second 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 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).

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext