Tuesday, April 9, 2019

Shift "Due Date" field on new Task record creation to Monday if it is the weekend(Sat or Sun)

- When creating a record (Create Record Action) via workflow, please use the SQL function below as a value for "Due Date" field for date to be shifted by one day or two to a Monday depending on if it is a Saturday or Sunday.

CASE WHEN (SUBSTR(to_char({today},'DAY'),0,3)) = 'SAT' THEN {today} +2 WHEN  (SUBSTR(to_char({today},'DAY'),0,3)) = 'SUN' THEN {today} +1  ELSE {today}  END

 

No comments:

Post a Comment