Discussions

Expand all | Collapse all

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

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

    Posted 02-08-2018 00:57
    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.


  • 2.  RE: How do I calculate if a person is 30 or under by the end of the current year?

    Top
    Contributor
    Posted 02-08-2018 01:42
    [Over 30? By End of Year] is a Checkbox formula field with this definition:
    AdjustYear([DOB], 30) <= LastDayOfYear(Today())


  • 3.  RE: How do I calculate if a person is 30 or under by the end of the current year?

    Posted 02-08-2018 14:50
    Thank you...FYI, this calculates over 30 not under 30.


  • 4.  RE: How do I calculate if a person is 30 or under by the end of the current year?

    Top
    Contributor
    Posted 02-08-2018 15:07
    You will have to issue an organization wide policy change to match up with my formula.