Saved search formula to set Due date 3 working days after the order date

The saved search formula will be in the result column which exclude the weekend dates and set the due date 3 days after order date in DD/MM/YYYY format

Formula text:

CASE TO_CHAR({trandate} + 3, ‘D’) WHEN ‘1’ THEN TO_CHAR({trandate} + 5, ‘DD/MM/YYYY’) WHEN ‘7’ THEN TO_CHAR({trandate} + 5, ‘DD/MM/YYYY’) ELSE TO_CHAR({trandate} + 3, ‘DD/MM/YYYY’) END

Leave a comment

Your email address will not be published. Required fields are marked *