function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
D 10D 10 

Business days calculation for Salesforce flow formula component

Hi All,

I have an scenario where I need to send email alerts for Case which has start date. Email alert should sent 10 business days before start date i.e start date - 10 business days. Can some one help? Please suggest me.

Thanks in Advance
Sai PraveenSai Praveen (Salesforce Developers) 
Hi,

Can you add another field in the object to calculate the email send date by ussing the below formula in below link which adds 10 business days to your start date.

https://salesforcemann.wordpress.com/2016/12/04/the-ultimate-salesforce-formula-to-add-business-days-to-a-date/

Now you can add a record triggered flow and add scheduled action and add the source date as the date field which you created and off set number as 1 and off set value as minute after.

Let me know if you need any other details.

If this solution helps, Please mark it as best answer.

Thanks,

 
The TechieThe Techie
Hi,

Use such formula -
https://thesalesforcetutorial.blogspot.com/2021/12/calculate-business-hours-by-using.html
inside
refer - https://www.youtube.com/watch?v=paFR6O_mbNk