0

DOB > Age > Child, Adult or Senior

when DOB is entered I would like age to show up in the field Age next to it and next to that have the field Age group classifying child (under 18), adult or senior (65+)

 

I've used date do enter DOB but on a mobile it's useless as the current date shows up and I can't type in the field

4 replies

null
    • Nick
    • 3 yrs ago
    • Reported - view

    For age -> formula field with code:

    age(DOB)

     

    For grouping -> formula field with code:

    if 'Age' < 18 then
    "Child"
    else
    if 'Age' < 65 then
    "Adult"
    else
    if 'Age' > 65 then "Senior" end
    end
    end

    • Fred
    • 3 yrs ago
    • Reported - view

    wouldn't Adult be if Age >= 18 and Age < 65?

    then Senior would be Age <= 65

    • caring4mobility
    • Brigitte_Honsbeek
    • 3 yrs ago
    • Reported - view

    thanks for being so helpful! Am new to this and don't have much knowledge of formula's

    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    It seems that the proposed formula would not return a value when the age is exactly 65. The third test (Age > 65) is not needed: if the age is not < 65 (second test), it is of course >= 65.

Login to reply

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 345Views