Calculating Change in Date

[Guest]

I am trying track the failure of equipment and I am wondering what the best
way to calculate a change in date for this would be. It is possible that I
would have multiple records for the same piece of equipment, and I would like
to be able to somehow track the difference between each record to determine
the effectiveness of repairs, and also possibly the difference between the
first and last entry for the overall lifespan of the equipment. Any
suggestions would be appreciated.

 

[John Vinson]

On Thu, 3 Feb 2005 06:59:05 -0800, Nick M <Nick

I am trying track the failure of equipment and I am wondering what the best
way to calculate a change in date for this would be. It is possible that I
would have multiple records for the same piece of equipment, and I would like
to be able to somehow track the difference between each record to determine
the effectiveness of repairs, and also possibly the difference between the
first and last entry for the overall lifespan of the equipment. Any
suggestions would be appreciated.

It's not at all clear what dates you want to compare, but take a look
at the DateDiff() function. Type Ctrl-G to open the VBA editor to get
the right Help file, and search Help for DateDiff.

John W. Vinson[MVP]