- 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