Skip to main content
Topics#FormulasFrage von neela prasad
neela prasad fragte in #Formulas
8. Feb. 2018, 10:16

I have a Time Dependent WorkFlow where I will send reminder for very 2 days after Rule Trigger Date Till 8 days and Will Suspend case after 8 days. But My Clients Need those days should be Business Working days Not Calendar days.Anybody Help me please?

6 Antworten
  1. Deepak R (Consultant)
    8. Feb. 2018, 10:34
    Hi Neela,

    1. According to my understanding you need to send reminder alerts from the reminder dates from the rule trigger date for the next 8 days in the intervals of 2 days. 

    2. So, four reminders in total.

    3. You will need four dates to be schedule the reminder emails

    4. Make use of one date field and 3 date formula field.

    5. The first date to be the rule trigger date, if their is a specific formula, use it to populate the first field.

    6. In the first date formula field check if it is saturday or sunday, and add 2 or 1 to move it to the next business day, by using the formula.

    IF(MOD(RuleTriggerDate-DATE(1900,1,1),7)=5,RuleTriggerDate+2,IF(MOD(RuleTriggerDate-DATE(1900,1,1),7)=6,RuleTriggerDate+1,RuleTriggerDate+2))

    The above formula is for calculating the first formula date from the RuleTriggerDate, using the first formula date you can use the same formula to calculate the next formula date, and the rest of the formula fields.

    7. Once you have all the dates, you can schedule the email alerts on those dates.

    I hope it helps

    RD

     
Antwort schreiben...
0/9000