Prev: Converting a Number
Next: csv linked file doesn't add to the same numbers?????
From: forest8 on 14 Mar 2010 23:20
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: Gina Whipp on 14 Mar 2010 23:33
forest8,

Under properties format the field on you form to fixed = 2 (if you want to
always have to decimal places) or Format = Standard and set Decimal Places
to 2

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"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: Tokyo Alex on 14 Mar 2010 23:48
Hi,

DateDiff("yyyy",...) always returns a whole number of years (which is why
you have to subtract one if the HireDate is greater than the current date).

So to get a fraction of year, you'll have to use:
YearsOfService: DateDiff("m",",[HireDate],Date()) / 12

You can then set the format to display as many or as few decimal places as
you like.

Cheers and HTH,
Alex.


"forest8" wrote:

> 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: forest8 on 15 Mar 2010 01:05
Hi

Will I have a problem if this person no longer works in my company?

There is an Exit Date in my database.

"Tokyo Alex" wrote:

> Hi,
>
> DateDiff("yyyy",...) always returns a whole number of years (which is why
> you have to subtract one if the HireDate is greater than the current date).
>
> So to get a fraction of year, you'll have to use:
> YearsOfService: DateDiff("m",",[HireDate],Date()) / 12
>
> You can then set the format to display as many or as few decimal places as
> you like.
>
> Cheers and HTH,
> Alex.
>
>
> "forest8" wrote:
>
> > 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: Tokyo Alex on 15 Mar 2010 01:18
Hi,

No, you shouldn't have a problem. Simply replace the "Date()" in the
expression with "[ExitDate]".

Cheers,
Alex.


"forest8" wrote:

> Hi
>
> Will I have a problem if this person no longer works in my company?
>
> There is an Exit Date in my database.
>
> "Tokyo Alex" wrote:
>
> > Hi,
> >
> > DateDiff("yyyy",...) always returns a whole number of years (which is why
> > you have to subtract one if the HireDate is greater than the current date).
> >
> > So to get a fraction of year, you'll have to use:
> > YearsOfService: DateDiff("m",",[HireDate],Date()) / 12
> >
> > You can then set the format to display as many or as few decimal places as
> > you like.
> >
> > Cheers and HTH,
> > Alex.
> >
> >
> > "forest8" wrote:
> >
> > > 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.
 |  Next  |  Last
Pages: 1 2
Prev: Converting a Number
Next: csv linked file doesn't add to the same numbers?????