This is what I have but it doesn't work when the Billing Frequency is Annually. Only working with Quarterly.
Starting Period current formula:
DATE( year(Date__c) + floor((month(Date__c) + 2 )/12) + if(and(month(Date__c)=12,2>=12),-1,0)
,
if( mod( month(Date__c) + 2 , 12 ) = 0, 12 , mod( month(Date__c) + 2 , 12 ))
,
min( day(Date__c),
case(
max( mod( month(Date__c) + 2 , 12 ) , 1),
9,30,
4,30,
6,30,
11,30,
2,28,
31
)
)
)
Ending Period current formula:
DATE( year(Date__c ) + floor((month(Date__c) + Asset__r.Months_Duration__c + 2 )/12) + if(and(month(Date__c)=12,Asset__r.Months_Duration__c + 2>=12),-1,0)
,
if( mod( month(Date__c) + Asset__r.Months_Duration__c + 2, 12 ) = 0, 12 , mod( month(Date__c) + Asset__r.Months_Duration__c + 2 , 12 ))
,
min( day(Date__c),
case(
max( mod( month(Date__c) + Asset__r.Months_Duration__c + 2, 12 ) , 1),
9,30,
4,30,
6,30,
11,30,
2,28,
31
)
)
)
1 risposta
I'm not seeing Billing Frequency field in your formula at all. Where does this come into play?
