Forum Discussion

RezaKhosrowabad's avatar
RezaKhosrowabad
Qrew Cadet
5 years ago

Need to stop the past due date from counting once a date is entered in the Return date field.

Hello,
My past due date field has the following formula.
Need to stop the past due date from counting once a date is entered in the Returned date field.

All fields on same table.

If(Today()-[Due Date]>Days(0),"<div style='color:red;'>" & ToDays(Today()-[Due Date]) & "</div>",
If(Today()-[Due Date]<=Days(0), "0"

------------------------------
Reza Khosrowabadi
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    var date EndDate = Min(Today(), [Returned Date]);

    If(
    $EndDate-[Due Date]>Days(0),"<div style='color:red;'>" & ToDays($EndDate-[Due Date]) & "</div>",
    $EndDate-[Due Date]<=Days(0), "0")

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • RezaKhosrowabad's avatar
      RezaKhosrowabad
      Qrew Cadet
      5 years ago
      Hello Mark,
      When i enter this formula, the Returned Date turns yellow and it says that the Returned date is not identifiend.
      what does that mean?
      thank you,
      Reza

      ------------------------------
      Reza Khosrowabadi
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        5 years ago
        Try using [Returned] instead of [Returned Date]. In initial remarks you stated the field was "Returned".

        ------------------------------
        Adam Keever
        ------------------------------