syntax:functions:age
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
syntax:functions:age [2017/12/23 09:16] – dmitry | syntax:functions:age [2021/08/29 22:34] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Age(date_as_number,date_as_number) ===== | + | ====== Age(date1, date2) ====== |
+ | Category: | ||
- | Number | + | \\ |
+ | =====Description===== | ||
+ | This function returns the number | ||
- | ^ | + | \\ |
- | | age(#2014-01-01, #2015-04-03) | + | =====Arguments===== |
- | | age(#1997-07-29, #2015-04-03) | + | ^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(# | ||
+ | |||
+ | | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[syntax: | ||
- | See also: | ||
- | * [[syntax: |
syntax/functions/age.txt · Last modified: 2021/08/30 01:55 by craigt