Convert Years of Age to DOB

[Nicos67]

Hi All,

How do I convery clients years of age eg (41.3) into client Date of Birt in a query

Thanks Nicos

 

[lupins46]

well I can't imagine how this calculation can be accurate.
After all, WHEN was the person 41.3 years old?

You can get a date using:

Dim Age as double, DOB as date
Age = 41.3

DOB = dateadd("yyyy",-1*(int(age),Date())-(365*(age-Int(age)))