Equinox Online Help - Language Reference - A to Z
Months |
|
|---|---|
| Applies to |       |
| Syntax | Months(Date1Expression, Date2Expression) |
| Action | [Function] Returns the number of calendar months between two dates. |
| Scope | Usable anywhere. |
| Notes | The function returns the number of whole calendar months between Date1Expression and Date2Expression (Date2Expression minus Date1Expression). |
| Category | Date handling |
| See Also | Years, Year, Day, Dayname, Dayofweek, Dayofyear, Dmy, Dmyadd, Leapyear, Month, MonthName, ServerDateTime, Today, Week, WeekOfYear, WeekStart |
| Example | This example calculates the number of months since an invoice was issued and stores the result in the variable DebtAge. DebtAge = Months(InvoiceDate, Today) |