calculate two dates

S

Spier2vb

Good morning

I have a Employees Table containing generel information about Employees one
field for hire date.
and i want make a query calculate between current date and hire date to
display the experience for each Employees How do I make this query ?

for example
current date 27/11/2008
hire date 01/10/2000
experience 26 days - 01 month - 08 years

Thanks for any assistance
 
M

Marshall Barton

Spier2vb said:
I have a Employees Table containing generel information about Employees one
field for hire date.
and i want make a query calculate between current date and hire date to
display the experience for each Employees How do I make this query ?

for example
current date 27/11/2008
hire date 01/10/2000
experience 26 days - 01 month - 08 years


This might be what you are looking forL
http://www.accessmvp.com/djsteele/Diff2Dates.html
 

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

Top