Date Calculation

[Michelle2]

I'm trying to do something similar to the question that Jimmy asked in December and can't seem to find the correct formula. I have an Age field that I want calculated from my Date Of Birth Field automatically. But I need it to be how old was that child on December 31, 2002. When I changed my date on my computer to say 12/31/02 and in the value section of my formula I put the following:

(Today() - DOB) / (365.25)

It puts something like 10.945666 and I just want it to say 10.

What am I doing wrong?

Thanks for your help in advance!!!!!!!!
Michelle

 

[paulbent]

Use Trunc() to remove the decimal portion.

Trunc(Today() - DOB) / (365.25), 0)

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk