diffMonths()
Returns the total number of months between two given dates.
Syntax
diffMonths(date1, date2)
- date1 - the date from which counting begins.
- date2 - the date at which counting ceases.
- Return type: Number
Sample usage
diffMonths('2021-10-11', '2021-11-11') returns 1.
Supported data types
Input type | Return type | Logic |
Date (x2) | Number | The function will count the number of months beginning with date1, and ending with date2. |
Unsupported data types | Null | Unsupported data types return Null. |


Updated 03 May 2023
Did this page help you?
Yes
No