Details about this thread
  • State Verified Answer
  • Replies 11 replies
  • Subscribers 309 subscribers
  • Views 3214 views
  • Users 0 members are here
Related content from around SugarClub

Ignoring Saturdays and Sundays

Jérôme Blanchard

Hi all,

I created a Process and I would like to put a Wait event with a duration of 3 days but I would like to ignore the week-end in this 3 days.

If the wait event start the Friday I would like that it stops wednesday.

Do you have a solution to do that?

Thank you for your help.

Best regards,

Parents Reply Children
  • 0 in reply to Ramana Raju Santhana

    Hi,

    I'm on Sugar Enterprise.

    I created a Process which send an email 3 days after creation of a cases. I want these 3 days are 3 business days. I don't want that Saturday and Sunday are part of the 3 days.

  • 0 in reply to Ramana Raju Santhana

    Hello Jerome,

    I have not tested this but I think it will work for you...

    1. Create a custom field in the module called 'thisday' that has a calculated value of dayofweek(today()). This will return an integer value from 1 to 7 where 1=Monday. When a record is updated, the custom field will recalculate to the current day's number.
    2. In the process, put a gateway that reads the value of this field as follows.
      • Day= 1 or 2 >> Wait 3 days
      • Day= 7 >> Wait 4 days
      • outcome 3: (set this as the default flow, no criteria needed) >> Wait 5 days

    Note: Make sure in your process that the evaluation of 'thisday' occurs on the same day that the process begins

     {SugarClub Administrator Edit: We're sorry, but this image is no longer available}  

    Please let me know if this works for your use case.

    Best Regards,

    Jill