Archives
The following is a list of bit manipulation and testing functions.
Function Description
SETOFF Sets to 0 (zero) a specified bit in a binary number.
SETON Sets to 1 a specified bit in a binary number.
TESTOFF Tests a specified bit in a binary number to see whether it is off.
TESTON Tests a specified bit in a binary number to see whether it is on.
Date/Time Functions
The following is a list of date/time functions.
Note Custom Date and Time formats allow additional characters, such as an alphabetic separator:
2001-01-23T10:32:59-0500 in ISO 8601 format
Function Description
ADDDAYS Adds a specified number of days to a date.
ADDHOURS Adds a specified number of hours to a date.
ADDMINUTES Adds a specified number of minutes to a date.
CURRENTDATE Returns the system date.
CURRENTDATETIME Returns the system date and time.
CURRENTTIME Returns the system time.
DATETONUMBER Returns an integer that results from counting the days from January 1, 1865, to the specified date.
DATETOTEXT Converts a date object or expression to a text item.
FROMDATETIME Converts a date/time item to a text string of a specified format.
MAX Returns the maximum value from a series of number, date, time or text values.
MIN Returns the minimum value from a series of number, date, time or text values.
NUMBERTODATE Converts an integer to a date that is in CCYYMMDD presentation. The integer is the number of days from January 1, 1865, to the specified date.
TEXTTODATE Converts text that is in CCYYMMDD or YYMMDD presentation to a date that looks like the text item.
TEXTTOTIME Converts an object defined as text to an object defined as time.
TIMETOTEXT Converts a time object or expression to a text item.
TODATETIME Converts a text string of a specified format to a date/time.
