Discussions

Expand all | Collapse all

Checkbox if date is more than one year ago

  • 1.  Checkbox if date is more than one year ago

    Posted 12-10-2018 23:17
    I'm looking for a formula that will check a check box if a date is more than a year ago. This is for archiving though an automation, and I'm sure it's simple, I just can't figure out how to make it happen.


  • 2.  RE: Checkbox if date is more than one year ago

    Posted 12-10-2018 23:24
    Are you OK with a simple formula field such as this formula for a formula checkbox field.

    AdjustYear([my date field],1) < Today()

    or if you want to get needlessly wordy

    IF(AdjustYear([my date field],1) < Today(), true)