You need to sign in to do that
Don't have an account?
TTagg
Loan Maturity Date Formula
I cannot seem to figure this formula out at all.
We have
Original Funding Date
Original Term
Formula (Original Maturity Date)
Example:
Original Funding Date: 3/10/2000
Original Term: 120
Needs to return: 2/10/2010
Formula being used:
DATE( YEAR( Original_Funding_Date__c ) + ( Original_Term__c /12) , MONTH(Original_Funding_Date__c )-1 ,DAY(Original_Funding_Date__c ) )
Problem: It seems to return an error when the month is in January/1. I'm assuming this is because salesforce doesn't understand how to count backward to 12 from 1.
Thank you so much for your help in advance!
We have
Original Funding Date
Original Term
Formula (Original Maturity Date)
Example:
Original Funding Date: 3/10/2000
Original Term: 120
Needs to return: 2/10/2010
Formula being used:
DATE( YEAR( Original_Funding_Date__c ) + ( Original_Term__c /12) , MONTH(Original_Funding_Date__c )-1 ,DAY(Original_Funding_Date__c ) )
Problem: It seems to return an error when the month is in January/1. I'm assuming this is because salesforce doesn't understand how to count backward to 12 from 1.
Thank you so much for your help in advance!
The following should handle this for you: