syntax:functions:age
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
syntax:functions:age [2015/03/20 12:52] – elenap | syntax:functions:age [2021/08/29 22:34] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Age(date_as_number,date_as_number) ===== | + | ====== Age(date1, date2) ====== |
+ | Category: | ||
+ | |||
+ | \\ | ||
+ | =====Description===== | ||
+ | This function returns the number of full years between two dates (//date1// and // | ||
+ | |||
+ | \\ | ||
+ | =====Arguments===== | ||
+ | ^Argument^Type^Description^ | ||
+ | |date1|Date or Number (date serial)|An expression representing a date.| | ||
+ | |date2|Date or Number (date serial)|An expression representing a date.| | ||
+ | |||
+ | **Return value type:** Number (Integer). | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | The result is a non-fractional number (integer), as an absolute value, so the dates can be entered in either order. | ||
+ | |||
+ | The //date1// and //date2// arguments can take any value or expression that evaluates to a date serial value. | ||
+ | * A date string: | ||
+ | * A date serial value: 43811 (the date serial for " | ||
+ | * A date value created using the [[syntax: | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | age(# | ||
+ | |||
+ | age(# | ||
+ | |||
+ | age(# | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[syntax: | ||
- | Number of years between two dates. Result is an integer (full, not fractional) number. |
syntax/functions/age.txt · Last modified: 2021/08/30 01:55 by craigt