Hi! I’m trying to get relative user age from entered birthdate. It’s not so easy, so i created one column with relative date between now and birthdate in mini format, then i created yet another column to replace “yr” with empty string (some kinda strcut or trim). Now i got “25” from DD-MM-YYYY for…

Thanks a lot! Column#1 with relative date between now and birthdate column#2 with Text function replacing “yr” in “25yr” to “” (25yr → 25) MATH column that make int from string with math function “column#2+1-1” so after that i could use it in IF-THEN-ELSE column!

How to get user age from birthday

Ask for Help

Robert_Petitto May 1, 2022, 9:12pm 6

Another solution is a math column with the following formula:

floor((year(now)-date)/365.25)

3 Likes

🆕 Date-time Math

Topic		Replies	Views
How to display age? Ask for Help	1	31	October 28, 2024
Comment déterminer l'âge à partir de la date de naissance Ask for Help	6	50	November 13, 2024
Calculate age in years and months Ask for Help	6	748	March 6, 2023
Show users birthday if it's today Ask for Help	5	62	August 6, 2024
Display a date calculation? Ask for Help	8	17	February 17, 2025

How to get user age from birthday

Related topics