Discussions

Expand all | Collapse all

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

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

    Posted 10-30-2018 11:23
    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)


  • 2.  RE: Problem -Checkbox Formula for Several Date Fields for Date that is Prior to or Equal to

    Posted 10-30-2018 13:04
    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.