Rounding down in access

[stevey03]

Hi

I'm trying to get and update query that will round a value down to the lower integer. The value is calculated using the datedif function:

Datediff(y,dateofbirth,now())

I want it to return the value in years to give an age, but as a whole number. Is there any type of round function that anyone knows of that could do this or any type of complex formula? I'm using Access 2000 with Windows XP.

 

[Norie]

Does that expression not actually return a whole number?

BTW the syntax should be Datediff("yyyy",dateofbirth,now())

According to help "y" returns the day of year, whatever that is.

EDIT

Are you using this as part of another expression?

eg Age:Datediff("y",dateofbirth,now())/365.25

If you are you could use something like this to get the whole number:

Age:Int(Datediff("y",dateofbirth,now())/365.25)

 

[stevey03]

Ok that kind of helps. My syntax was wrong, I just need to figure out the rounding down part. I was thinkin of sticking that within an IIf query. I'll give that a go and let you know how i get on.