Date Query - Ages?

[mmshafi]

In querry want to calculate age in years & months. already uses datediff() "YYYY" function. it gives only years. should be a way in single statement to clalculate years & months same time.

 

[jzwp22]

You can use the datediff() function with the month option and incorporate some calculations to split into years and months. The following is not tested:

Int(datediff("m", date(), dateofbirth)/12) & " years and " & datediff("m",date(), dateofbirth)-(Int(datediff("m", date(), dateofbirth)/12)*12) & " months"

 

[ConneXionLost]

Here are a couple of references:

Microsoft

Tek-tips

Cheers,