Checkbox if date is more than one year ago

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
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.
Photo of Steve


  • 460 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
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)