'Quarterly' is every three months
'Semi-Annual' is every six months
And 'Annual' is every 12 months.
Any idea of the formular required on this based on the below?
3 respuestas
Hi Brooke, This is similar to the other question you posted. Please try this:
ADDMONTHS(Start_Date__c,
(CEILING((12*(YEAR(TODAY())-YEAR(Start_Date__c)) + (MONTH(TODAY()) - MONTH(Start_Date__c))) / CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)) + IF(AND(MOD(MONTH(TODAY()) - MONTH(Start_Date__c), CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)) = 0, DAY(TODAY()) >= DAY(Start_Date__c)), 1, 0))
*
CASE(Payment_Frequency__c,
"Monthly", 1,
"Quarterly", 3,
"Semi-Annual", 6,
"Annual", 12,
null)
)
