Forum Discussion

NakiaHarringto1's avatar
NakiaHarringto1
Qrew Trainee
6 years ago

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

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)
Formulas and functions

1 Reply

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.