Difference between revisions of "Value"

From AgileApps Support Wiki
imported>Evelyn
m
 
imported>Aeric
 
Line 5: Line 5:
:<tt>FUNCTION ('dString', int, value)</tt>
:<tt>FUNCTION ('dString', int, value)</tt>


:When specified in a Formula Function with the [[Formula_Functions#Conventions|int]] (integer) argument, the value specifies the unit of time that the integer represents. See [[#Available Values|Available Values]] for the complete list.
:When specified in a Formula Function with the [[Formula Functions#Conventions|int]] (integer) argument, the value specifies the unit of time that the integer represents. See [[#Available Values|Available Values]] for the complete list.


;Usage:
;Usage:

Latest revision as of 00:32, 14 May 2014

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'