Value

value defines a unit of time and is an argument in date- and date/time-related Formula Functions.

Example

FUNCTION ('dString', int, value)

When specified in a Formula Function with the int (integer) argument, the value specifies the unit of time that the integer represents. See Available Values for the complete list.

Usage

• If the 'dString' argument is of type date or date/time, then 'HOUR' and 'MINUTE' are allowed Values.
• If the 'dString' argument is of type time, then 'DAY' and 'MONTH' and 'YEAR' are required Values and 'HOUR' and 'MINUTE' are optional.

Available Values

Values are units of time, and are used with the int (integer) argument in Date and Date/Time Formula Functions.

DAY — The value of the integer in days

MONTH — The value of the integer in months

YEAR — The value of the integer in years

HOUR — The value of the integer in hours

MINUTE — The value of the integer in minutes

Examples

For the DATESUB formula: DATESUB ('dString', int, 'value')

DATESUB('12/06/2009', 2, 'MONTH') = '10/06/2009'

DATESUB('12/06/2009', 2, 'YEAR') = '12/06/2007'