Hi,
I have birth days in this format YYYY-MM-DD.
I want to calculate their ages.
Per exemple, someone born 1950-03-28 would be 70 years old.
Not sure how to do that. Any idea?
Thanks
Solved
Calculate an age with a birth day
+20- Enthusiast
Best answer by ebygomm
I'd probably use the Date/Time Functions, so parse the attribute named birthdate into date format, calculate the difference in years from today's date and round down
@floor(@DateTimeDiff(@DateTimeNow(),@DateTimeParse(@Value(birthdate),%Y-%m-%d),Years))
Convert both dates to seconds since epoch (%Es), find the difference, then convert back to years. If you don't need to take leap years into account, the easiest is to divide by 31556952 (the number of seconds in a non-leap year).
Or to be completely accurate (using leap years and all), first convert the dates to FME timestamps then use the DateTimeCalculator:
+39- Influencer
- Best Answer
I'd probably use the Date/Time Functions, so parse the attribute named birthdate into date format, calculate the difference in years from today's date and round down
@floor(@DateTimeDiff(@DateTimeNow(),@DateTimeParse(@Value(birthdate),%Y-%m-%d),Years))
+20- Enthusiast
david_r wrote:
Or to be completely accurate (using leap years and all), first convert the dates to FME timestamps then use the DateTimeCalculator:
Nice I didn't know we could do that :D
I need to put an AttributeRounder after to take out de decimals though.
Thanks!!
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.