I marvel what's the satisfactory technique for doing an age calculation?
I actually have a Birthday date in my dataset, and I would really like to calculate how antique the are on the modern-day time while the record is running, e.g.
Year(CurrentDate()) - Year()
https://www.agecalculator.help/
The trouble with the only above is, that it display the age of the folks withinside the modern-day year, although it won't were their birthday yet.
I am lacking the DateDiffInYears characteristic however if I use this
Round(DateDiffInDays(, CurrentDate()) / 365, 0)
I am nonetheless now no longer getting the proper effects for a number of the birthdays and the above assumption does now no longer take bounce years into consideration.
So despite the fact that Lumira has a few effective calculation, I nonetheless suppose a few capabilities are lacking, and I actually have up to now no concept on the way to try this calculation right in Lumira
In Excel I can use
=DATEDIFF(Birthday;TODAY();"y")
to get the precise variety of years, so the way to do the identical in Lumira?