Prev: Converting a Number
Next: csv linked file doesn't add to the same numbers?????
From: John W. Vinson on 15 Mar 2010 02:21
On Sun, 14 Mar 2010 22:05:01 -0700, forest8
<forest8(a)discussions.microsoft.com> 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" <forest8(a)discussions.microsoft.com> 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" <forest8(a)discussions.microsoft.com> 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  | 
Pages: 1 2
Prev: Converting a Number
Next: csv linked file doesn't add to the same numbers?????