I have this formula which calculates the number of months between two dates:
(12 * (YEAR( SBQQ__EndDate__c ) - YEAR( SBQQ__StartDate__c ))) + (MONTH(SBQQ__EndDate__c) - MONTH(SBQQ__StartDate__c))
I'd like to amend this, IF the calculation result is less than 1 (so 0) i'd like this to be ignored and a blank value inserted, or not inserted as teh case may be.
Could someone send some directly and knowledge my way.
Thanks
2 answers
If
(
12 * (YEAR( SBQQ__EndDate__c ) - YEAR( SBQQ__StartDate__c ))) + (MONTH(SBQQ__EndDate__c) - MONTH(SBQQ__StartDate__c) < 1, NULL,
12 * (YEAR( SBQQ__EndDate__c ) - YEAR( SBQQ__StartDate__c ))) + (MONTH(SBQQ__EndDate__c) - MONTH(SBQQ__StartDate__c)
)
