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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • khopper
    Senior Member
    • Sep 2017
    • 329

    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?
  • khopper
    Senior Member
    • Sep 2017
    • 329

    #2
    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

    Comment

    • tanya
      Senior Member
      • Jun 2014
      • 4308

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

      Comment

      Working...