Forum Discussion

RezaKhosrowabad's avatar
RezaKhosrowabad
Qrew Cadet
5 years ago

Can someone help me with a Past Due formula?

I have a start date and a due date and i want the past due date to start with 1 counting the number of days past due.
thank you,
Reza

------------------------------
Reza Khosrowabadi
------------------------------
  • Can you explain what happens when the record stops being past due?  Can you give an example?  ie if his was a Library book due back on November 30th, when does the clock stop for the book having being returned.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • Hello Mark,
    No end date. i review a file. about 30 days to respond which is the due date. anytime after the due date is past due and no end date. just counting the days after the due date.
    thanks.

    ------------------------------
    Reza Khosrowabadi
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      How does the record know when you have reviewed the file?  Otherwise the past due counter will just count up forever.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • RezaKhosrowabad's avatar
        RezaKhosrowabad
        Qrew Cadet
        I have a review date and a due date and i need a past due date which is any number of days after the due date.
        thanks.

        ------------------------------
        Reza Khosrowabadi
        ------------------------------