From: John W. Vinson on 15 Mar 2010 02:21 On Sun, 14 Mar 2010 22:05:01 -0700, forest8 wrote: >Will I have a problem if this person no longer works in my company? > You can get finer granularity and handle both current and fromer employees with: YearsOfService: Round(DateDiff("d",",[HireDate],NZ([ExitDate],Date())) / 365,2) -- John W. Vinson [MVP] From: James Hall on 28 Mar 2010 14:58 Jhall(a)myglnc.com "forest8" wrote in message news:540F2F2A-5D02-45A4-9BC3-8C4C0F112987(a)microsoft.com...> Hi there > > In my database, I have used the following calculation to determine a > person's years of service. > > YearsOfService: DateDiff("yyyy",[HireDate],Date()) > -IIf(Format([HireDate],"mmdd")>Format(Date(),"mmdd"),1,0) > > A t the moment, the result is rounded to the nearest whole number. > > I would like to see at least 2 decimal places. At the moment, if someone > has > been with the company less than 1 year, I get 0 years. I would like to see > if > it's .75 years or .5 years, etc. > > Thank you in advance for your help. From: James Hall on 2 Apr 2010 10:31 "forest8" wrote in message news:540F2F2A-5D02-45A4-9BC3-8C4C0F112987(a)microsoft.com...> Hi there > > In my database, I have used the following calculation to determine a > person's years of service. > > YearsOfService: DateDiff("yyyy",[HireDate],Date()) > -IIf(Format([HireDate],"mmdd")>Format(Date(),"mmdd"),1,0) > > A t the moment, the result is rounded to the nearest whole number. > > I would like to see at least 2 decimal places. At the moment, if someone > has > been with the company less than 1 year, I get 0 years. I would like to see > if > it's .75 years or .5 years, etc. > > Thank you in advance for your help. First  |  Prev  |