How do I calculate if a person is 30 or under by the end of the current year?

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered
How do I calculate if a person is 30 or under by the end of the current year if I know his/her birth date and the date of the last date of the current year? I am thinking of using a rich text formula field.
Photo of George Bramhall

George Bramhall

  • 80 Points 75 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,322 Points 20k badge 2x thumb
[Over 30? By End of Year] is a Checkbox formula field with this definition:
AdjustYear([DOB], 30) <= LastDayOfYear(Today())
(Edited)
Photo of George Bramhall

George Bramhall

  • 80 Points 75 badge 2x thumb
Thank you...FYI, this calculates over 30 not under 30.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,272 Points 20k badge 2x thumb
You will have to issue an organization wide policy change to match up with my formula.