calc date of birth in query

[a]

I have query with this fields

TodayDate: Date () (Field type expression)

Dateofbirth (field type date)

CalcDateOfBirth: DateDiff("yyyy";[dateofbirth];[todaydate])

-------------------

My problem is (Calcdateofbirth) display the result by year only

I want to display the (Calcdateofbirth) like this

Yyyy/mm/dd

25:04:03

I mean I want to combine the year and month and day

Any help

Thank you

 

[Douglas J. Steele]

Assuming that what you're trying to calculate is the person's age in years,
months and days, see http://www.accessmvp.com/DJSteele/Diff2Dates.html