How do you round a number DOWN (for age)?

  • Thread starter Thread starter janeewalker
  • Start date Start date
J

janeewalker

I have an age field that is calucaled from the date of birth

Age: DateDiff("d",[DOB],Now())/365.25

If someone is 65.6 - it shows 66 - I need this to ROUND DOWN - there used to
be a rounddown feature in Access.
 
janeewalker said:
I have an age field that is calucaled from the date of birth

Age: DateDiff("d",[DOB],Now())/365.25

If someone is 65.6 - it shows 66 - I need this to ROUND DOWN - there used
to
be a rounddown feature in Access.
Click to expand...


When was that? I've been working with Access for quite a few years, and I
never heard of such a function. You may be thinking of the Int() or Fix()
function, but I don't know of any RoundDown() function.

That said, your formula for age is not really correct. Here's a link to
some better ones:

http://www.mvps.org/access/datetime/date0001.htm
Date/Time: Calculate Age of a person
 
Back
Top