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 M...
Formulas and functions
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.