Checkbox if date is more than one year ago
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.
Forum Discussion
1 Reply
- 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)
