Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
nksfnksf 

Formula Field to Get Future Date

Hi Guys I need your help with this Formula field. It is very urgent.
We have Formula Field Billing Frequency and we have PurchaseDate Standard Date Field
I need to create a Formula Field to Calculate the Future Bill Date
Scenario:
If we have Billing_Frequency__c = Monthly and PurchaseDate = 8/1/15 and EndDate = 12/1/15 
Suppose Today() Date is 9/23/15
then if Today() Date is > PurchaseDate and < EndDate then this Formula Field should show Future Bill Date as 10/1/15 
so when Today() Date be 10/2/15 then this Formula Field should show Future Date as 11/1/15
If Today() Date is <= PurachaseDate then this Formula Field show just show PurchaseDate
In case Today()Date is < EndDate then this Field should be Blank.

If we have Billing_Frequency__c = Quarterly and PurchaseDate = 8/1/15 and EndDate = 12/1/16 
Suppose Today() Date is 9/23/15
then if Today() Date is > PurchaseDate and < EndDate then this Formula Field should show Future Bill Date as 2/1/16
so when Today() Date be 2/2/16 then this Formula Field should show Future Date as 5/1/16
If Today() Date is <= PurachaseDate then this Formula Field show just show PurchaseDate
In case Today()Date is < EndDate then this Field should be Blank.
 
ProlayProlay
IF( ISPICKVAL( Billing_Frequency__c ,'Monthly' ) &&  (PurchaseDate__c >  TODAY() &&  EndDate__c < TODAY() ),DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),

IF( ISPICKVAL( Billing_Frequency__c ,'Quarterly' ) &&  (PurchaseDate__c >  TODAY() &&  EndDate__c < TODAY()),DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY())), NULL))
Hope this helps!