Hello,
no, there are no such filter. But it is planned.
Report/Workflow Calcualation, After X Business days (no weekend days - Sat/Sun)
Collapse
X
-
Similar to this MySQL CASE When Expression?
CASE
WHEN DAYOFWEEK (DATE(NOW( ))) IN (1) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 2 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (2) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 2 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (3) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 2 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (4) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 2 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (5) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 4 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (6) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 4 DAY)
WHEN DAYOFWEEK (DATE(NOW( ))) IN (7) THEN account_date BETWEEN DATE(NOW( )) AND DATE(NOW( ) + INTERVAL 3 DAY)
ENDLeave a comment:
Leave a comment: