Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

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


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

      Comment

      Working...
      X