syntax:functions:agemonths
This is an old revision of the document!
Table of Contents
AgeMonths(date1, date2)
Category: Date and Time function
Description
This function returns the number of full months between two dates (date1 and date2).
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 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 the Date function: date("2019-12-12","yyyy-MM-dd").
Examples
agemonths(#1960-05-10, #2021-08-29) //Returns 735.
agemonths(#2021-08-29, #1960-05-10) //Returns 735. (Dates are in reversed order from above.)
agemonths(#1825-06-15, #2050-06-15) //Returns 2700.
See also
syntax/functions/agemonths.1630291206.txt.gz · Last modified: 2021/08/29 22:40 by craigt