Datediff function

[Guest]

hello
for some reason the datediff function is not working. I want to work out the
age of a student eg. 19 yrs 8 months based on Date of Birth and current date
how should i do it?

 

[Douglas J. Steele]

Take a look at "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[(PeteCresswell)]

Per Database User:

for some reason the datediff function is not working. I want to work out the
age of a student eg. 19 yrs 8 months based on Date of Birth and current date
how should i do it?

What are you doing now that doesn't work?