Details about this thread
  • State Verified Answer
  • Replies 11 replies
  • Subscribers 309 subscribers
  • Views 3210 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
  • 0

    Hi Jerome

    Can you be little bit clear on your question so that i can help you. Sugar version you are working on, what Process you have created and what actually you want to do.

    Best Regards

    S Ramana Raju

  • 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

Reply
  • 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

Children