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
Calculate age in years and months Ask for Help	6	736	March 6, 2023
Calculate and Display User's Age (from Date of Birth) Ask for Help	15	3257	June 12, 2022
Ask about glide table math Ask for Help	20	152	February 14, 2024
Math - NOW variable not proposed Ask for Help	4	254	June 6, 2022
Column GetYear() Ask for Help	3	318	June 1, 2020

How to get user age from birthday

Related topics