Skip to main content
Question

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

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

    • anomDiebolt
    • Registered
    • February 8, 2018
    [Over 30? By End of Year] is a Checkbox formula field with this definition:
    AdjustYear([DOB], 30) <= LastDayOfYear(Today())
    GeorgeBramhall2
    Forum|alt.badge.img+11
    Thank you...FYI, this calculates over 30 not under 30.
    Terms & ConditionsAccessibility statement