Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rachel LinderRachel Linder 

What is the formula to calculate a due date as = today plus 3 business days

We would like to set a default date for a Due date field as "Today plus 3 business days".
Is this possible? If so, what would the formula be?
 
Neetu_BansalNeetu_Bansal
Hi Rachel,

There are two ways to accomplish this:
  1. Create Business Hours in your org
  2. Create custom settings to store the all the global holidays and then in the apex code, we can calculate working days, after that populate in Due date.
I can help you out on this.

Thanks,
Neetu
Rachel LinderRachel Linder
Any help would be so grateful and appreciate.
Neetu_BansalNeetu_Bansal
Hi Rachel,

Can you please contact me either on my gmail id: neetu.bansal.5@gmail.com or Skype id: neetu.bansal.5
So I can help you out.

Thanks,
Neetu
Adrienne LeeAdrienne Lee
Hi Rachel, 

I have a similar requirement to display the agreement expiry date to show start date + 3 years. Any help with the formula is appreciated.
 
Neetu_BansalNeetu_Bansal
Hello Adrienne,

Do you want to show on the UI while creating record or after saving the record?

Thanks,
Neetu
Adrienne LeeAdrienne Lee
Hi Neetu, 

After the record is saved.... I have figure out this formula kinda work 90%
DATE(FLOOR((YEAR(Warranty_Start_Date__c)+3)),MOD( MONTH(Warranty_Start_Date__c)+36,12), DAY(Warranty_Start_Date__c))-1

the other 10% of the records are showing #Error! which I am trying to figure WHY ???

Any experience shared by everyone is much appreciated.... 

Thanks
Adrienne