length of service

[Guest]

I want to calculate length of service for staff using their start date. I
have in the past used a formula to calculate age from date of birth but when
I altered it and used it for length of service it gave me 0 for staff who
have joined less than one year ago. Is it possible to alter the formula (or
use something similar), to give me the answer in years and months? Formula
is below:
=DateDiff("yyyy",[DOB],Date())+(Format([DOB],"mmdd")>Format(Date(),"mmdd"))

Thanks

 

[Allen Browne]

Try:
A More Complete DateDiff Function
at:
http://members.rogers.com/douglas.j.steele/Diff2Dates.html

 

[Brendan Reynolds]

In the following SQL statement, the 'Years' and 'Months' columns demonstrate
how to get the two values separately, while the 'Years/Months' column
demonstrates how to concatenate them in one column ...

SELECT DateDiff("yyyy",[TheDate],Date()) AS Years,
DateDiff("m",[TheDate],Date()) Mod 12 AS Months,
DateDiff("yyyy",[TheDate],Date()) & "/" & DateDiff("m",[TheDate],Date()) Mod
12 AS [Years/Months]
FROM TheTable;

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.