How to get the ages from birthdays

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.

1 Like