2 Replies Latest reply on Aug 14, 2017 3:17 AM by Jason Kleinhans

    Overdue Customers

    Jason Kleinhans

      Good day all


      Hope you can assist


      I have a view to calculate all customers that are 60 days and over , however I also have customers that is 2 days , 5 days 20 days overdue in the same view which should not be listed in the 60 days overdue view. The customer should only appear when it is 60 days and over

      my calculation I have used is


      IF DATEDIFF('day', ([Due Date]), TODAY()) > (IFNULL([Suspension Period],60)) THEN "Suspended" // Customers will be suspended if they reach 60 days which is there cut off

      ELSEIF DATEDIFF('day', [Due Date], TODAY()) > (IFNULL([Suspension Period],60))-7 THEN "One week before suspension"  // Customers that is one week before they get suspended