date query

[viralbhatt]

Hi,

Need Help!!!

How can i write query that can display Age from given date of birth. I need age on 4th april 05.

DateOfBirth
01/04/2001
04/04/2002
10/03/1999
02/02/1995
05/06/2000
21/12/2000
10/03/1999

thank you

 

[TessB]

Age: DateDiff("yyyy",[DateOfBirth],#04/04/2005#)

 

[viralbhatt]

Thank you

It is working