Why do we use MONTHSDIFFFROMNOW function?
The MONTHSDIFFFROMNOW function is used to calculate the number of months between a given date and today’s date. For example, If today’s date is 27/06/2025, and you want to find out how many months have passed since 27/01/2025,this function will return 5, as there are 5 full months between 27/01/2025 and 27/06/2025.
Syntax- MONTHSDIFFFROMNOW(date, dateFormat)
Example- MONTHSDIFFFROMNOW(“2025-01-27”, “yyyy-MM-dd”)