Report/Workflow Calcualation, After X Business days (no weekend days - Sat/Sun)

Collapse
X
 
  • Time
  • Show
Clear All
new posts

  • tanya
    replied
    Hello,
    no, there are no such filter. But it is planned.
    Last edited by tanya; 06-12-2018, 08:51 AM.

    Leave a comment:


  • khopper
    replied
    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)
    END

    Leave a comment:


  • Report/Workflow Calcualation, After X Business days (no weekend days - Sat/Sun)

    I have been looking through the forums on this one with no luck.
    Is there way for a report to show me items older than x # of business days only, not counting the weekend days sat/sun?
Working...