If you have a column with birthdays in Date format, you can calculate ages by using time_length
, interval
and today
functions.
You can add the following calculation in the “Create Calculation” dialog.
time_length(interval(birthday, today()), "years")
Here is a sample output. I ran this on 6/8/2020. As you see, it takes care of leap years.