Logic to exclude weekends in flow [closed]

Question

While implementing below approach to calculate working days excluding weekends, I am also trying to exclude Holidays that I've added to salesforce org as well. Is it possible to add few resources and elements in the same flow to implement it?

Answer 1

I would do it with a batch apex and a custom field of type number number_working_days__c.

That way you can schedule it to run only on worked days (and avoid week-ends) by using the correct cron expression to schedule it with the System.Schedule method

The batch would query the database for records matching your conditions : status not equal to your list and not completed as well.

Then you just add 1 to your custom field and the batch then update all records with the newly incremented counter.

Finally, as long as the status is completed or one of the value in your list, the number is not incremented and you have your information available on each record.

documentation for batch apex : Batch Apex

documentation for scheduling and cron expression examples : Apex Scheduler

Flow approach :

use a Schedule-Triggered flow

define a schedule

define filtering criterias : exclude all the status values in your list + the completed status

Then increase the custom field number_of_working_days__c by 1 and Update the record.

To test if it's a week day (Monday to Friday) or the weekend (Saturday or Sunday) create a flow variable of type Number as below

Then add a decision at the beginning of the flow to test if it's weekend or not, if it's weekend just stop the flow, else let the flow logic run.

Answer 2

The "stop calculating when X, and resume when Y" bit means that you cannot do this with a formula field.

Formulas are evaluated every time the record is accessed, and they do not hold the result of evaluating the formula.

Workflow rules are also being phased out. It doesn't matter what your preference is here, you need to use a Flow or Apex to achieve this.