Skip to main content
Question

Checkbox if date is more than one year ago

  • December 11, 2018
  • 0 replies
  • 44 views
Forum|alt.badge.img+7
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.
    This topic has been closed for replies.

    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)


    Terms & ConditionsAccessibility statement