length of service

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top