0

field automatically with birth date

How can i create a formula with "birth date" and a field with the different range of age. For example: i have the the field with 0-18, the field 18-30 and the field 30-50.

I want so set automatically the right range with the insert of the birth date.
It's possible? How? Thanks

1 reply

null
    • Andrea
    • 6 yrs ago
    • Reported - view

    You must create a field named "Birth date" and a formula field where paste:

    let gap_year := year(today()) - date('Birth date');
    if gap_year <= 18 then
    "0-18"
    else
    if gap_year <= 30 then
    "19-30"
    else
    if gap_year <= 50 then "31-50" end
    end
    end

Login to reply

Content aside

  • 6 yrs agoLast active
  • 1Replies
  • 1482Views