calculate two dates

[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

 

[Marshall Barton]

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