calc date of birth in query

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calc date of birth in query 3
#Name? error in Formula 5
WHats wrong with this query? 4
Calculate date 7
How do I post a result of a query to a text box? 0
Date of birth question 5
convert date 1
A date function in Access using VB 12

Top