You need to sign in to do that
Don't have an account?
domdick
Help on the formula date field
Hello,
I have following formula that works fine if the start date is 01/10/2013 and terms_month is 3 then it gives me the result on end date 31/12/2013
But the business prospective we need to add additional day on the end date so the results would auto calculate end date to 01/01/2014.
Any idea with an example???
formula so far:
DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c)) - 1
(DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c)) - 1)+1
DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c))
I just took '-1' out from your formula...