Calculate Months between two dates? [duplicate]
To calculate number of months between two dates you could just use YEAR and MONTH: (YEAR(SBQQ__EndDate__c) * 12 + (MONTH(SBQQ__EndDate__c) - 1) - YEAR(SBQQ__StartDate__c) * 12 + (MONTH(SBQQ__StartDate__c) - 1) )This should give you the correct result in all cases, although note that partial months would still be…
Answered Aug 2, 2021 · 2.5K Views Read answer →