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
-
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 -
wouldn't Adult be if Age >= 18 and Age < 65?
then Senior would be Age <= 65
-
thanks for being so helpful! Am new to this and don't have much knowledge of formula's
-
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.
Content aside
- 3 yrs agoLast active
- 4Replies
- 346Views