AgileApps Support Wiki Pre Release

value

From AgileApps Support Wiki

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'