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