Skip to main content
Question

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

  • February 4, 2021
  • 0 replies
  • 37 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement