Re: I need help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

For this I would probably use the following expression and I wouldn't worry
about a high-degree of accuracy

Int((Date()-[Date Deployed]) / 365.25)

That formula will be accurate within a day or two of the number of years
since a computer has been deployed. If you want partial years then drop the
Int.

If you absolutely require the formula to be totally accurate in terms of
years, then you can use an express like the following to return the age in
years

DateDiff("yyyy",[Date Deployed],Date()) - Abs( Format(Date(),"mmdd") >
Format([Date Deployed],"mmdd") )

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"naja" <naja@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:098EC891-7574-4417-8994-1A05F7401FE9@xxxxxxxxxxxxxxxx
Sorry that my messages are not that clear. Let me see if I can break it
down
better.

I have a raw data that I download from an application.
This file contains information about when our desktop was deploy, who has
it, etc, etc.
my company implemented a project to replace old desktop that are 5 years
or
oldest.
this data has a column that gives me on what date it was deployed.
So I need a column that tells me the number of years that this desktop
has.

I hope this is more clear.

"John W. Vinson" wrote:

On Thu, 25 Oct 2007 13:22:00 -0700, naja <naja@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

The reason why I'm saying that the output should be numbers not date is
because the purchased field is a date, but my replace column should be
numbers.

WHAT numbers? What do the numbers mean, and where do you want them to
come
from?

John W. Vinson [MVP]



.

Relevant Pages