Problem -Checkbox Formula for Several Date Fields for Date that is Prior to or Equal to

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I cannot get the box to un-check if the date matches or is before the Actual Date Mail Card. 

[Group - Benefit Period - Mail ID Cards By]  By 12/27/17
[Mail ID Cards By:] 12/28/17
Checkbox - ID Mail Cards past due.

My checkbox field is Mail ID Cards Past Due. I thought if I tell the field what to do if it us true ut would not check the box if the field is equal to or prior to the ID Cards Mail by Date.

My formula is 
If(Today()>[Group - Benefit Period - Mail ID Cards By] or [Mail ID Cards By:]>[Group - Benefit Period - Mail ID Cards By],true)
Photo of Nakia

Nakia

  • 40 Points

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
In your example it says

or [Mail ID Cards By:]>[Group - Benefit Period - Mail ID Cards By]

putting in the values

12/28/17 >  12/27/17

That statement is true, so the result of the formula is correct for how it is written. 

Maybe what you need to do is to state the condition in English words that you are trying to achieve and we will help you put that into a formula.