Differences

This shows you the differences between two versions of the page.

--- syntax:functions:age [2017/12/23 09:16] – dmitry
+++ syntax:functions:age [2021/08/30 01:55] (current) – [Arguments] craigt
@@ Line 1: / Line 1: @@
-===== Age(date_as_number,date_as_number) =====
+====== Age(date1, date2) ======
+Category:  Date and Time function
-Number of years between two dates represented as number. Result is an integer (full, not fractional) number.
+\\
+=====Description=====
+This function returns the number of full years between two dates (//date1// and //date2//).
-^  Example  ^  Result  ^
+\\
-| age(#2014-01-01, #2015-04-03)  |  1  |
+=====Arguments=====
-| age(#1997-07-29, #2015-04-03)  |  17  |
+^Argument^Type^Description^
+|date1|Date or Number (date serial)|An expression representing a date.  The date value to calculate the difference from.|
+|date2|Date or Number (date serial)|An expression representing a date.  The date value to calculate the difference to.|
+**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.  Examples include:
+  * A date string:  #2019-12-12
+  * A date serial value: 43811 (the date serial for "2019-12-12")
+  * A date value created using any of the Date/Time functions that returns a date serial value.
+\\
+=====Examples=====
+  age(#1960-05-10, #2021-08-29)  //Returns 61.
+  age(#2021-08-29, #1960-05-10)  //Returns 61.  (Dates are in reversed order from above.)
+  age(#1825-06-15, #2050-06-15)  //Returns 225.
+\\
+=====See also=====
+  * [[syntax:functions:agemonths|AgeMonths(date1,date2)]]
-See also:
-  * [[syntax:functions:agemonths]]